[ROOT] dt SELECT CountP AS NumberOfEntities, CountPRec AS NumberOfPropertiesOfEntities, ToPropertyStream.Length() AS SizeInDatabase ORDER BY NumberOfEntities DESC > TITLE Database statistics (Note: Slow query)
23 items
| DimAccountCollectionId | NumberOfEntities | NumberOfPropertiesOfEntities | SizeInDatabase |
|---|---|---|---|
| FactInternetSaleReason | 64515 | 258060 | 6853201 |
| FactResellerSale | 60855 | 1348656 | 42933582 |
| FactInternetSale | 60398 | 847723 | 24653506 |
| FactFinance | 39409 | 275863 | 5990477 |
| DimCustomer | 18484 | 473170 | 14467205 |
| FactProductDescription | 15168 | 60672 | 7942861 |
| FactCurrencyRate | 14264 | 71320 | 2148122 |
| FactSurveyResponse | 2727 | 19089 | 551038 |
| DimReseller | 701 | 12512 | 327347 |
| DimGeography | 655 | 7205 | 200658 |
| DimProduct | 606 | 15181 | 7060065 |
| DimEmployee | 296 | 7177 | 6341608 |
| FactSalesQuota | 163 | 978 | 19680 |
| FactCallCenter | 120 | 1560 | 33064 |
| DimCurrency | 105 | 315 | 4725 |
| DimAccount | 99 | 785 | 16831 |
| DimProductSubcategory | 37 | 222 | 5044 |
| DimPromotion | 16 | 244 | 7589 |
| DimOrganization | 14 | 69 | 1479 |
| DimSalesReason | 10 | 40 | 578 |
| DimSalesTerritory | 10 | 50 | 586996 |
| DimDepartment | 7 | 20 | 375 |
| DimProductCategory | 4 | 20 | 393 |
Generated 2024-10-13 00:47:20.719 UTC