Table: Product Table: Product| Property | Value |
|---|---|
| Name | Product |
| ID | 1717581157 |
| Owner | dbo |
| Schema | Production |
| Filegroup | PRIMARY |
| Data Size (KB) | 104 KB |
| Index Size (KB) | 120 KB |
| Rows | 504 |
| Unused (KB) | 16 KB |
| ANSI Null On |
|
| Quoted Identifier |
|
| Lock Escalation | TABLE |
| Lock On Bulk Load |
|
| Lob Data Space | |
| Filestream Data Space ID | |
| Has Unchecked Assembly Data |
|
| Text In Row Limit (bytes) | Option not set |
| Large Value Types Out Of Row |
|
| FullText Change Tracking On |
|
| Tracked By Cdc |
|
| Published |
|
| Schema Published |
|
| Replicated |
|
| Replication Filter |
|
| Merge Published |
|
| Sync Tran Subscribed |
|
| MS Shipped |
|
| Modify Date | 8/8/2010 5:23:45 PM |
| Create Date | 8/8/2010 5:21:51 PM |
| Name | Value |
|---|---|
| MS_Description | Products sold or used in the manfacturing of sold products. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | ProductID | int |
|
|
|
| 2 | Name | Name |
|
|
|
| 3 | ProductNumber | nvarchar(25) |
|
|
|
| 4 | MakeFlag | Flag |
|
|
|
| 5 | FinishedGoodsFlag | Flag |
|
|
|
| 6 | Color | nvarchar(15) |
|
|
|
| 7 | SafetyStockLevel | smallint |
|
|
|
| 8 | ReorderPoint | smallint |
|
|
|
| 9 | StandardCost | money |
|
|
|
| 10 | ListPrice | money |
|
|
|
| 11 | Size | nvarchar(5) |
|
|
|
| 12 | SizeUnitMeasureCode | nchar(3) |
|
|
|
| 13 | WeightUnitMeasureCode | nchar(3) |
|
|
|
| 14 | Weight | decimal(8,2) |
|
|
|
| 15 | DaysToManufacture | int |
|
|
|
| 16 | ProductLine | nchar(2) |
|
|
|
| 17 | Class | nchar(2) |
|
|
|
| 18 | Style | nchar(2) |
|
|
|
| 19 | ProductSubcategoryID | int |
|
|
|
| 20 | ProductModelID | int |
|
|
|
| 21 | SellStartDate | datetime |
|
|
|
| 22 | SellEndDate | datetime |
|
|
|
| 23 | DiscontinuedDate | datetime |
|
|
|
| 24 | rowguid | uniqueidentifier |
|
|
|
| 25 | ModifiedDate | datetime |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| ProductID | 1 | 1 | 999 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_Product_ProductID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| ProductID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_Product_UnitMeasure_SizeUnitMeasureCode | Production.UnitMeasure | No action | No action |
| FK_Product_UnitMeasure_WeightUnitMeasureCode | Production.UnitMeasure | No action | No action |
| FK_Product_ProductModel_ProductModelID | Production.ProductModel | No action | No action |
| FK_Product_ProductSubcategory_ProductSubcategoryID | Production.ProductSubcategory | No action | No action |
| Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|---|---|
| CK_Product_SafetyStockLevel | 7 | SafetyStockLevel | ([SafetyStockLevel]>(0)) |
|
|
|
|
|
| CK_Product_ReorderPoint | 8 | ReorderPoint | ([ReorderPoint]>(0)) |
|
|
|
|
|
| CK_Product_StandardCost | 9 | StandardCost | ([StandardCost]>=(0.00)) |
|
|
|
|
|
| CK_Product_ListPrice | 10 | ListPrice | ([ListPrice]>=(0.00)) |
|
|
|
|
|
| CK_Product_Weight | 14 | Weight | ([Weight]>(0.00)) |
|
|
|
|
|
| CK_Product_DaysToManufacture | 15 | DaysToManufacture | ([DaysToManufacture]>=(0)) |
|
|
|
|
|
| CK_Product_ProductLine | 16 | ProductLine | (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL) |
|
|
|
|
|
| CK_Product_Class | 17 | Class | (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL) |
|
|
|
|
|
| CK_Product_Style | 18 | Style | (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL) |
|
|
|
|
|
| Name | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|
| CK_Product_SellEndDate | ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL) |
|
|
|
|
|
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_Product_MakeFlag | MakeFlag | ((1)) |
|
MS_Description | Default constraint value of 1 |
| DF_Product_FinishedGoodsFlag | FinishedGoodsFlag | ((1)) |
|
MS_Description | Default constraint value of 1 |
| DF_Product_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_Product_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_Product_ProductID | CLUSTERED |
|
|
|
|
|
| AK_Product_ProductNumber | NONCLUSTERED |
|
|
|
|
|
| AK_Product_Name | NONCLUSTERED |
|
|
|
|
|
| AK_Product_rowguid | NONCLUSTERED |
|
|
|
|
|
| Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object |
|---|---|---|---|---|---|---|---|---|
| FK_BillOfMaterials_Product_ProductAssemblyID | 1 |
|
|
|
No action | No action |
|
Production.BillOfMaterials |
| FK_BillOfMaterials_Product_ComponentID | 1 |
|
|
|
No action | No action |
|
Production.BillOfMaterials |
| FK_ProductCostHistory_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductCostHistory |
| FK_ProductDocument_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductDocument |
| FK_ProductInventory_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductInventory |
| FK_ProductListPriceHistory_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductListPriceHistory |
| FK_ProductProductPhoto_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductProductPhoto |
| FK_ProductReview_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.ProductReview |
| FK_ProductVendor_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Purchasing.ProductVendor |
| FK_PurchaseOrderDetail_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Purchasing.PurchaseOrderDetail |
| FK_ShoppingCartItem_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Sales.ShoppingCartItem |
| FK_SpecialOfferProduct_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Sales.SpecialOfferProduct |
| FK_TransactionHistory_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.TransactionHistory |
| FK_WorkOrder_Product_ProductID | 1 |
|
|
|
No action | No action |
|
Production.WorkOrder |
| Permission | Grantor | Grant | With Grant Option | Deny |
|---|---|---|---|---|
| Alter | dbo |
|
||
| Control | ||||
| Delete | ||||
| Insert | dbo |
|
||
| References | ||||
| Select | ||||
| Take Ownership | ||||
| Update | ||||
| View Change Tracking | ||||
| View Definition |
| Permission | Grantor | Grant | With Grant | Deny |
|---|---|---|---|---|
| SELECT | dbo |
|
||
| REFERENCES | ||||
| UPDATE |
| Permission | Grantor | Grant | With Grant | Deny |
|---|---|---|---|---|
| SELECT | ||||
| REFERENCES | ||||
| UPDATE | dbo |
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_Product_ProductID | Aug 8 2010 5:22PM | 504 | 504 | 200 | 1 | 4 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001984127 | 4 | ProductID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 1 |
| 4 | 2 | 1 | 2 | 1 |
| 317 | 1 | 1 | 1 | 1 |
| 319 | 1 | 1 | 1 | 1 |
| 321 | 1 | 1 | 1 | 1 |
| 323 | 1 | 1 | 1 | 1 |
| 325 | 1 | 1 | 1 | 1 |
| 327 | 1 | 1 | 1 | 1 |
| 331 | 3 | 1 | 3 | 1 |
| 341 | 1 | 1 | 1 | 1 |
| 343 | 1 | 1 | 1 | 1 |
| 345 | 1 | 1 | 1 | 1 |
| 347 | 1 | 1 | 1 | 1 |
| 349 | 1 | 1 | 1 | 1 |
| 351 | 1 | 1 | 1 | 1 |
| 357 | 3 | 1 | 3 | 1 |
| 361 | 3 | 1 | 3 | 1 |
| 363 | 1 | 1 | 1 | 1 |
| 365 | 1 | 1 | 1 | 1 |
| 367 | 1 | 1 | 1 | 1 |
| 369 | 1 | 1 | 1 | 1 |
| 371 | 1 | 1 | 1 | 1 |
| 373 | 1 | 1 | 1 | 1 |
| 375 | 1 | 1 | 1 | 1 |
| 377 | 1 | 1 | 1 | 1 |
| 379 | 1 | 1 | 1 | 1 |
| 381 | 1 | 1 | 1 | 1 |
| 383 | 1 | 1 | 1 | 1 |
| 385 | 1 | 1 | 1 | 1 |
| 389 | 3 | 1 | 3 | 1 |
| 393 | 3 | 1 | 3 | 1 |
| 397 | 3 | 1 | 3 | 1 |
| 399 | 1 | 1 | 1 | 1 |
| 401 | 1 | 1 | 1 | 1 |
| 403 | 1 | 1 | 1 | 1 |
| 405 | 1 | 1 | 1 | 1 |
| 407 | 1 | 1 | 1 | 1 |
| 409 | 1 | 1 | 1 | 1 |
| 411 | 1 | 1 | 1 | 1 |
| 413 | 1 | 1 | 1 | 1 |
| 415 | 1 | 1 | 1 | 1 |
| 417 | 1 | 1 | 1 | 1 |
| 419 | 1 | 1 | 1 | 1 |
| 421 | 1 | 1 | 1 | 1 |
| 423 | 1 | 1 | 1 | 1 |
| 425 | 1 | 1 | 1 | 1 |
| 427 | 1 | 1 | 1 | 1 |
| 429 | 1 | 1 | 1 | 1 |
| 431 | 1 | 1 | 1 | 1 |
| 433 | 1 | 1 | 1 | 1 |
| 435 | 1 | 1 | 1 | 1 |
| 437 | 1 | 1 | 1 | 1 |
| 439 | 1 | 1 | 1 | 1 |
| 441 | 1 | 1 | 1 | 1 |
| 443 | 1 | 1 | 1 | 1 |
| 445 | 1 | 1 | 1 | 1 |
| 449 | 3 | 1 | 3 | 1 |
| 453 | 3 | 1 | 3 | 1 |
| 457 | 3 | 1 | 3 | 1 |
| 461 | 3 | 1 | 3 | 1 |
| 465 | 3 | 1 | 3 | 1 |
| 467 | 1 | 1 | 1 | 1 |
| 469 | 1 | 1 | 1 | 1 |
| 473 | 3 | 1 | 3 | 1 |
| 475 | 1 | 1 | 1 | 1 |
| 479 | 3 | 1 | 3 | 1 |
| 481 | 1 | 1 | 1 | 1 |
| 483 | 1 | 1 | 1 | 1 |
| 485 | 1 | 1 | 1 | 1 |
| 487 | 1 | 1 | 1 | 1 |
| 489 | 1 | 1 | 1 | 1 |
| 491 | 1 | 1 | 1 | 1 |
| 493 | 1 | 1 | 1 | 1 |
| 495 | 1 | 1 | 1 | 1 |
| 497 | 1 | 1 | 1 | 1 |
| 505 | 1 | 1 | 1 | 1 |
| 507 | 1 | 1 | 1 | 1 |
| 509 | 1 | 1 | 1 | 1 |
| 511 | 1 | 1 | 1 | 1 |
| 513 | 1 | 1 | 1 | 1 |
| 515 | 1 | 1 | 1 | 1 |
| 519 | 3 | 1 | 3 | 1 |
| 521 | 1 | 1 | 1 | 1 |
| 523 | 1 | 1 | 1 | 1 |
| 525 | 1 | 1 | 1 | 1 |
| 529 | 3 | 1 | 3 | 1 |
| 533 | 3 | 1 | 3 | 1 |
| 680 | 3 | 1 | 3 | 1 |
| 707 | 1 | 1 | 1 | 1 |
| 709 | 1 | 1 | 1 | 1 |
| 713 | 3 | 1 | 3 | 1 |
| 717 | 3 | 1 | 3 | 1 |
| 721 | 3 | 1 | 3 | 1 |
| 725 | 3 | 1 | 3 | 1 |
| 729 | 3 | 1 | 3 | 1 |
| 731 | 1 | 1 | 1 | 1 |
| 733 | 1 | 1 | 1 | 1 |
| 737 | 3 | 1 | 3 | 1 |
| 739 | 1 | 1 | 1 | 1 |
| 743 | 3 | 1 | 3 | 1 |
| 745 | 1 | 1 | 1 | 1 |
| 747 | 1 | 1 | 1 | 1 |
| 749 | 1 | 1 | 1 | 1 |
| 751 | 1 | 1 | 1 | 1 |
| 753 | 1 | 1 | 1 | 1 |
| 755 | 1 | 1 | 1 | 1 |
| 759 | 3 | 1 | 3 | 1 |
| 761 | 1 | 1 | 1 | 1 |
| 763 | 1 | 1 | 1 | 1 |
| 765 | 1 | 1 | 1 | 1 |
| 767 | 1 | 1 | 1 | 1 |
| 769 | 1 | 1 | 1 | 1 |
| 771 | 1 | 1 | 1 | 1 |
| 773 | 1 | 1 | 1 | 1 |
| 775 | 1 | 1 | 1 | 1 |
| 777 | 1 | 1 | 1 | 1 |
| 779 | 1 | 1 | 1 | 1 |
| 781 | 1 | 1 | 1 | 1 |
| 783 | 1 | 1 | 1 | 1 |
| 785 | 1 | 1 | 1 | 1 |
| 787 | 1 | 1 | 1 | 1 |
| 789 | 1 | 1 | 1 | 1 |
| 791 | 1 | 1 | 1 | 1 |
| 793 | 1 | 1 | 1 | 1 |
| 795 | 1 | 1 | 1 | 1 |
| 797 | 1 | 1 | 1 | 1 |
| 799 | 1 | 1 | 1 | 1 |
| 801 | 1 | 1 | 1 | 1 |
| 803 | 1 | 1 | 1 | 1 |
| 805 | 1 | 1 | 1 | 1 |
| 807 | 1 | 1 | 1 | 1 |
| 809 | 1 | 1 | 1 | 1 |
| 811 | 1 | 1 | 1 | 1 |
| 813 | 1 | 1 | 1 | 1 |
| 815 | 1 | 1 | 1 | 1 |
| 817 | 1 | 1 | 1 | 1 |
| 819 | 1 | 1 | 1 | 1 |
| 823 | 3 | 1 | 3 | 1 |
| 825 | 1 | 1 | 1 | 1 |
| 827 | 1 | 1 | 1 | 1 |
| 829 | 1 | 1 | 1 | 1 |
| 831 | 1 | 1 | 1 | 1 |
| 833 | 1 | 1 | 1 | 1 |
| 835 | 1 | 1 | 1 | 1 |
| 837 | 1 | 1 | 1 | 1 |
| 841 | 3 | 1 | 3 | 1 |
| 843 | 1 | 1 | 1 | 1 |
| 845 | 1 | 1 | 1 | 1 |
| 847 | 1 | 1 | 1 | 1 |
| 849 | 1 | 1 | 1 | 1 |
| 851 | 1 | 1 | 1 | 1 |
| 853 | 1 | 1 | 1 | 1 |
| 855 | 1 | 1 | 1 | 1 |
| 857 | 1 | 1 | 1 | 1 |
| 859 | 1 | 1 | 1 | 1 |
| 861 | 1 | 1 | 1 | 1 |
| 863 | 1 | 1 | 1 | 1 |
| 865 | 1 | 1 | 1 | 1 |
| 867 | 1 | 1 | 1 | 1 |
| 869 | 1 | 1 | 1 | 1 |
| 871 | 1 | 1 | 1 | 1 |
| 873 | 1 | 1 | 1 | 1 |
| 875 | 1 | 1 | 1 | 1 |
| 877 | 1 | 1 | 1 | 1 |
| 879 | 1 | 1 | 1 | 1 |
| 881 | 1 | 1 | 1 | 1 |
| 883 | 1 | 1 | 1 | 1 |
| 885 | 1 | 1 | 1 | 1 |
| 887 | 1 | 1 | 1 | 1 |
| 889 | 1 | 1 | 1 | 1 |
| 891 | 1 | 1 | 1 | 1 |
| 893 | 1 | 1 | 1 | 1 |
| 896 | 2 | 1 | 2 | 1 |
| 900 | 3 | 1 | 3 | 1 |
| 904 | 3 | 1 | 3 | 1 |
| 908 | 3 | 1 | 3 | 1 |
| 912 | 3 | 1 | 3 | 1 |
| 916 | 3 | 1 | 3 | 1 |
| 920 | 3 | 1 | 3 | 1 |
| 924 | 3 | 1 | 3 | 1 |
| 928 | 3 | 1 | 3 | 1 |
| 932 | 3 | 1 | 3 | 1 |
| 936 | 3 | 1 | 3 | 1 |
| 940 | 3 | 1 | 3 | 1 |
| 944 | 3 | 1 | 3 | 1 |
| 948 | 3 | 1 | 3 | 1 |
| 952 | 3 | 1 | 3 | 1 |
| 956 | 3 | 1 | 3 | 1 |
| 960 | 3 | 1 | 3 | 1 |
| 964 | 3 | 1 | 3 | 1 |
| 968 | 3 | 1 | 3 | 1 |
| 972 | 3 | 1 | 3 | 1 |
| 976 | 3 | 1 | 3 | 1 |
| 980 | 3 | 1 | 3 | 1 |
| 984 | 3 | 1 | 3 | 1 |
| 988 | 3 | 1 | 3 | 1 |
| 992 | 3 | 1 | 3 | 1 |
| 996 | 3 | 1 | 3 | 1 |
| 998 | 1 | 1 | 1 | 1 |
| 999 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Product_ProductNumber | Aug 8 2010 5:23PM | 504 | 504 | 196 | 1 | 20.39286 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001984127 | 16.39286 | ProductNumber |
| 0.001984127 | 20.39286 | ProductNumber, ProductID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| AR-5381 | 0 | 1 | 0 | 1 |
| BB-8107 | 2 | 1 | 2 | 1 |
| BC-M005 | 1 | 1 | 1 | 1 |
| BE-2349 | 1 | 1 | 1 | 1 |
| BK-M18B-40 | 1 | 1 | 1 | 1 |
| BK-M18B-44 | 1 | 1 | 1 | 1 |
| BK-M18B-52 | 1 | 1 | 1 | 1 |
| BK-M18S-42 | 1 | 1 | 1 | 1 |
| BK-M38S-38 | 3 | 1 | 3 | 1 |
| BK-M38S-42 | 1 | 1 | 1 | 1 |
| BK-M47B-38 | 1 | 1 | 1 | 1 |
| BK-M47B-44 | 1 | 1 | 1 | 1 |
| BK-M68B-38 | 1 | 1 | 1 | 1 |
| BK-M68B-46 | 1 | 1 | 1 | 1 |
| BK-M68S-42 | 1 | 1 | 1 | 1 |
| BK-M82B-44 | 3 | 1 | 3 | 1 |
| BK-M82S-44 | 3 | 1 | 3 | 1 |
| BK-R19B-44 | 1 | 1 | 1 | 1 |
| BK-R19B-52 | 1 | 1 | 1 | 1 |
| BK-R50B-44 | 1 | 1 | 1 | 1 |
| BK-R50B-52 | 1 | 1 | 1 | 1 |
| BK-R50B-60 | 1 | 1 | 1 | 1 |
| BK-R50R-44 | 1 | 1 | 1 | 1 |
| BK-R50R-52 | 1 | 1 | 1 | 1 |
| BK-R50R-60 | 1 | 1 | 1 | 1 |
| BK-R64Y-38 | 1 | 1 | 1 | 1 |
| BK-R64Y-42 | 1 | 1 | 1 | 1 |
| BK-R64Y-48 | 1 | 1 | 1 | 1 |
| BK-R68R-48 | 1 | 1 | 1 | 1 |
| BK-R79Y-40 | 3 | 1 | 3 | 1 |
| BK-R89B-44 | 3 | 1 | 3 | 1 |
| BK-R89R-44 | 3 | 1 | 3 | 1 |
| BK-R89R-52 | 1 | 1 | 1 | 1 |
| BK-R93R-44 | 1 | 1 | 1 | 1 |
| BK-R93R-52 | 1 | 1 | 1 | 1 |
| BK-R93R-62 | 1 | 1 | 1 | 1 |
| BK-T18U-50 | 1 | 1 | 1 | 1 |
| BK-T18U-58 | 1 | 1 | 1 | 1 |
| BK-T18Y-44 | 1 | 1 | 1 | 1 |
| BK-T18Y-54 | 1 | 1 | 1 | 1 |
| BK-T18Y-62 | 1 | 1 | 1 | 1 |
| BK-T44U-50 | 1 | 1 | 1 | 1 |
| BK-T44U-60 | 1 | 1 | 1 | 1 |
| BK-T79U-50 | 1 | 1 | 1 | 1 |
| BK-T79U-60 | 1 | 1 | 1 | 1 |
| BK-T79Y-50 | 1 | 1 | 1 | 1 |
| BK-T79Y-60 | 1 | 1 | 1 | 1 |
| CA-1098 | 1 | 1 | 1 | 1 |
| CA-6738 | 1 | 1 | 1 | 1 |
| CB-2903 | 1 | 1 | 1 | 1 |
| CL-9009 | 1 | 1 | 1 | 1 |
| CR-7833 | 1 | 1 | 1 | 1 |
| CS-2812 | 1 | 1 | 1 | 1 |
| CS-6583 | 1 | 1 | 1 | 1 |
| DC-8732 | 1 | 1 | 1 | 1 |
| DT-2377 | 1 | 1 | 1 | 1 |
| FB-9873 | 3 | 1 | 3 | 1 |
| FE-3760 | 3 | 1 | 3 | 1 |
| FK-5136 | 3 | 1 | 3 | 1 |
| FR-M21B-42 | 3 | 1 | 3 | 1 |
| FR-M21S-40 | 3 | 1 | 3 | 1 |
| FR-M21S-44 | 1 | 1 | 1 | 1 |
| FR-M21S-52 | 1 | 1 | 1 | 1 |
| FR-M63B-48 | 3 | 1 | 3 | 1 |
| FR-M63S-40 | 1 | 1 | 1 | 1 |
| FR-M94B-42 | 3 | 1 | 3 | 1 |
| FR-M94B-46 | 1 | 1 | 1 | 1 |
| FR-M94S-38 | 1 | 1 | 1 | 1 |
| FR-M94S-44 | 1 | 1 | 1 | 1 |
| FR-M94S-52 | 1 | 1 | 1 | 1 |
| FR-R38B-48 | 1 | 1 | 1 | 1 |
| FR-R38B-58 | 1 | 1 | 1 | 1 |
| FR-R38B-62 | 1 | 1 | 1 | 1 |
| FR-R38R-48 | 1 | 1 | 1 | 1 |
| FR-R38R-58 | 1 | 1 | 1 | 1 |
| FR-R38R-62 | 1 | 1 | 1 | 1 |
| FR-R72R-48 | 1 | 1 | 1 | 1 |
| FR-R72R-58 | 1 | 1 | 1 | 1 |
| FR-R72Y-38 | 1 | 1 | 1 | 1 |
| FR-R72Y-42 | 1 | 1 | 1 | 1 |
| FR-R72Y-48 | 1 | 1 | 1 | 1 |
| FR-R92B-58 | 3 | 1 | 3 | 1 |
| FR-R92R-44 | 1 | 1 | 1 | 1 |
| FR-R92R-52 | 1 | 1 | 1 | 1 |
| FR-R92R-58 | 1 | 1 | 1 | 1 |
| FR-T67U-54 | 3 | 1 | 3 | 1 |
| FR-T67Y-50 | 3 | 1 | 3 | 1 |
| FR-T98U-46 | 3 | 1 | 3 | 1 |
| FR-T98U-54 | 1 | 1 | 1 | 1 |
| FR-T98Y-46 | 1 | 1 | 1 | 1 |
| FW-1000 | 3 | 1 | 3 | 1 |
| FW-3800 | 3 | 1 | 3 | 1 |
| FW-9160 | 3 | 1 | 3 | 1 |
| FW-R623 | 3 | 1 | 3 | 1 |
| GL-F110-L | 3 | 1 | 3 | 1 |
| GL-F110-S | 1 | 1 | 1 | 1 |
| GL-H102-M | 1 | 1 | 1 | 1 |
| GT-1209 | 3 | 1 | 3 | 1 |
| HB-M243 | 1 | 1 | 1 | 1 |
| HB-T721 | 5 | 1 | 5 | 1 |
| HJ-1213 | 1 | 1 | 1 | 1 |
| HJ-1420 | 1 | 1 | 1 | 1 |
| HJ-3410 | 1 | 1 | 1 | 1 |
| HJ-3816 | 1 | 1 | 1 | 1 |
| HJ-5161 | 1 | 1 | 1 | 1 |
| HJ-7161 | 3 | 1 | 3 | 1 |
| HJ-9080 | 1 | 1 | 1 | 1 |
| HL-U509 | 1 | 1 | 1 | 1 |
| HL-U509-R | 1 | 1 | 1 | 1 |
| HN-1032 | 1 | 1 | 1 | 1 |
| HN-1220 | 1 | 1 | 1 | 1 |
| HN-1420 | 1 | 1 | 1 | 1 |
| HN-3410 | 1 | 1 | 1 | 1 |
| HN-3816 | 1 | 1 | 1 | 1 |
| HN-4402 | 1 | 1 | 1 | 1 |
| HN-5162 | 1 | 1 | 1 | 1 |
| HN-5811 | 1 | 1 | 1 | 1 |
| HN-6320 | 1 | 1 | 1 | 1 |
| HN-7162 | 1 | 1 | 1 | 1 |
| HN-9161 | 1 | 1 | 1 | 1 |
| HS-0296 | 1 | 1 | 1 | 1 |
| HS-3479 | 1 | 1 | 1 | 1 |
| HT-8019 | 1 | 1 | 1 | 1 |
| HU-8998 | 1 | 1 | 1 | 1 |
| KW-4091 | 1 | 1 | 1 | 1 |
| LE-1200 | 1 | 1 | 1 | 1 |
| LE-1400 | 1 | 1 | 1 | 1 |
| LE-7160 | 3 | 1 | 3 | 1 |
| LI-1000 | 1 | 1 | 1 | 1 |
| LI-1201 | 1 | 1 | 1 | 1 |
| LI-3800 | 1 | 1 | 1 | 1 |
| LI-5800 | 1 | 1 | 1 | 1 |
| LI-7160 | 1 | 1 | 1 | 1 |
| LJ-0192-L | 1 | 1 | 1 | 1 |
| LJ-0192-S | 1 | 1 | 1 | 1 |
| LJ-1420 | 3 | 1 | 3 | 1 |
| LJ-3410 | 1 | 1 | 1 | 1 |
| LJ-3816 | 1 | 1 | 1 | 1 |
| LJ-5161 | 1 | 1 | 1 | 1 |
| LJ-5811 | 1 | 1 | 1 | 1 |
| LJ-7161 | 1 | 1 | 1 | 1 |
| LJ-9080 | 1 | 1 | 1 | 1 |
| LN-1024 | 1 | 1 | 1 | 1 |
| LN-1224 | 3 | 1 | 3 | 1 |
| LN-1428 | 1 | 1 | 1 | 1 |
| LN-3416 | 1 | 1 | 1 | 1 |
| LN-3824 | 1 | 1 | 1 | 1 |
| LN-5161 | 1 | 1 | 1 | 1 |
| LN-5400 | 1 | 1 | 1 | 1 |
| LN-5818 | 1 | 1 | 1 | 1 |
| LN-8320 | 3 | 1 | 3 | 1 |
| LN-9161 | 1 | 1 | 1 | 1 |
| LR-2398 | 1 | 1 | 1 | 1 |
| LT-H902 | 1 | 1 | 1 | 1 |
| LT-T990 | 1 | 1 | 1 | 1 |
| LW-1200 | 1 | 1 | 1 | 1 |
| LW-1400 | 1 | 1 | 1 | 1 |
| LW-3800 | 1 | 1 | 1 | 1 |
| LW-6000 | 3 | 1 | 3 | 1 |
| LW-8000 | 1 | 1 | 1 | 1 |
| MA-7075 | 1 | 1 | 1 | 1 |
| MB-6061 | 1 | 1 | 1 | 1 |
| MP-2503 | 1 | 1 | 1 | 1 |
| MS-0253 | 1 | 1 | 1 | 1 |
| MS-1981 | 1 | 1 | 1 | 1 |
| MS-2341 | 1 | 1 | 1 | 1 |
| MS-6061 | 1 | 1 | 1 | 1 |
| NI-4127 | 1 | 1 | 1 | 1 |
| PA-361R | 2 | 1 | 2 | 1 |
| PA-T100 | 3 | 1 | 3 | 1 |
| PD-M562 | 3 | 1 | 3 | 1 |
| PD-T852 | 3 | 1 | 3 | 1 |
| RA-2345 | 3 | 1 | 3 | 1 |
| RC-0291 | 3 | 1 | 3 | 1 |
| RM-M692 | 3 | 1 | 3 | 1 |
| RM-R800 | 3 | 1 | 3 | 1 |
| RW-M928 | 3 | 1 | 3 | 1 |
| RW-T905 | 3 | 1 | 3 | 1 |
| SA-R127 | 3 | 1 | 3 | 1 |
| SA-T612 | 3 | 1 | 3 | 1 |
| SB-M891-S | 3 | 1 | 3 | 1 |
| SE-M798 | 3 | 1 | 3 | 1 |
| SE-R995 | 3 | 1 | 3 | 1 |
| SH-4562 | 3 | 1 | 3 | 1 |
| SH-M897-S | 3 | 1 | 3 | 1 |
| SH-W890-S | 3 | 1 | 3 | 1 |
| SJ-0194-X | 3 | 1 | 3 | 1 |
| SO-B909-L | 3 | 1 | 3 | 1 |
| SP-2981 | 3 | 1 | 3 | 1 |
| ST-9828 | 3 | 1 | 3 | 1 |
| TI-M267 | 3 | 1 | 3 | 1 |
| TI-R628 | 3 | 1 | 3 | 1 |
| TP-0923 | 3 | 1 | 3 | 1 |
| VE-C304-L | 3 | 1 | 3 | 1 |
| VE-C304-S | 1 | 1 | 1 | 1 |
| WB-H098 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Product_Name | Aug 8 2010 5:23PM | 504 | 504 | 198 | 1 | 40.81746 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001984127 | 36.81746 | Name |
| 0.001984127 | 40.81746 | Name, ProductID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| Adjustable Race | 0 | 1 | 0 | 1 |
| BB Ball Bearing | 2 | 1 | 2 | 1 |
| Bike Wash - Dissolver | 1 | 1 | 1 | 1 |
| Cable Lock | 1 | 1 | 1 | 1 |
| Chain Stays | 1 | 1 | 1 | 1 |
| Chainring Bolts | 1 | 1 | 1 | 1 |
| Classic Vest, L | 1 | 1 | 1 | 1 |
| Classic Vest, S | 1 | 1 | 1 | 1 |
| Decal 1 | 3 | 1 | 3 | 1 |
| Down Tube | 1 | 1 | 1 | 1 |
| External Lock Washer 2 | 1 | 1 | 1 | 1 |
| External Lock Washer 4 | 1 | 1 | 1 | 1 |
| External Lock Washer 6 | 1 | 1 | 1 | 1 |
| External Lock Washer 8 | 1 | 1 | 1 | 1 |
| Fender Set - Mountain | 1 | 1 | 1 | 1 |
| Flat Washer 4 | 3 | 1 | 3 | 1 |
| Flat Washer 8 | 3 | 1 | 3 | 1 |
| Fork Crown | 1 | 1 | 1 | 1 |
| Freewheel | 1 | 1 | 1 | 1 |
| Front Derailleur | 1 | 1 | 1 | 1 |
| Front Derailleur Linkage | 1 | 1 | 1 | 1 |
| Full-Finger Gloves, M | 1 | 1 | 1 | 1 |
| Guide Pulley | 1 | 1 | 1 | 1 |
| Half-Finger Gloves, M | 1 | 1 | 1 | 1 |
| Handlebar Tube | 1 | 1 | 1 | 1 |
| Headlights - Dual-Beam | 1 | 1 | 1 | 1 |
| Headset Ball Bearings | 1 | 1 | 1 | 1 |
| Hex Nut 10 | 1 | 1 | 1 | 1 |
| Hex Nut 16 | 5 | 1 | 5 | 1 |
| Hex Nut 2 | 3 | 1 | 3 | 1 |
| Hex Nut 23 | 3 | 1 | 3 | 1 |
| Hex Nut 4 | 1 | 1 | 1 | 1 |
| Hex Nut 6 | 1 | 1 | 1 | 1 |
| Hex Nut 8 | 1 | 1 | 1 | 1 |
| Hitch Rack - 4-Bike | 1 | 1 | 1 | 1 |
| HL Crankarm | 1 | 1 | 1 | 1 |
| HL Fork | 1 | 1 | 1 | 1 |
| HL Headset | 1 | 1 | 1 | 1 |
| HL Mountain Frame - Black, 38 | 1 | 1 | 1 | 1 |
| HL Mountain Frame - Black, 44 | 1 | 1 | 1 | 1 |
| HL Mountain Frame - Black, 48 | 1 | 1 | 1 | 1 |
| HL Mountain Frame - Silver, 42 | 1 | 1 | 1 | 1 |
| HL Mountain Frame - Silver, 46 | 1 | 1 | 1 | 1 |
| HL Mountain Front Wheel | 1 | 1 | 1 | 1 |
| HL Mountain Pedal | 1 | 1 | 1 | 1 |
| HL Mountain Rim | 1 | 1 | 1 | 1 |
| HL Mountain Seat/Saddle | 1 | 1 | 1 | 1 |
| HL Nipple | 1 | 1 | 1 | 1 |
| HL Road Frame - Black, 48 | 1 | 1 | 1 | 1 |
| HL Road Frame - Black, 58 | 1 | 1 | 1 | 1 |
| HL Road Frame - Red, 44 | 1 | 1 | 1 | 1 |
| HL Road Frame - Red, 52 | 1 | 1 | 1 | 1 |
| HL Road Frame - Red, 58 | 1 | 1 | 1 | 1 |
| HL Road Front Wheel | 1 | 1 | 1 | 1 |
| HL Road Pedal | 1 | 1 | 1 | 1 |
| HL Road Seat/Saddle | 3 | 1 | 3 | 1 |
| HL Touring Frame - Blue, 46 | 3 | 1 | 3 | 1 |
| HL Touring Frame - Yellow, 46 | 3 | 1 | 3 | 1 |
| HL Touring Handlebars | 3 | 1 | 3 | 1 |
| Internal Lock Washer 1 | 3 | 1 | 3 | 1 |
| Internal Lock Washer 2 | 1 | 1 | 1 | 1 |
| Internal Lock Washer 4 | 1 | 1 | 1 | 1 |
| Internal Lock Washer 8 | 3 | 1 | 3 | 1 |
| Keyed Washer | 1 | 1 | 1 | 1 |
| LL Fork | 3 | 1 | 3 | 1 |
| LL Headset | 1 | 1 | 1 | 1 |
| LL Mountain Frame - Black, 40 | 1 | 1 | 1 | 1 |
| LL Mountain Frame - Black, 44 | 1 | 1 | 1 | 1 |
| LL Mountain Frame - Black, 52 | 1 | 1 | 1 | 1 |
| LL Mountain Frame - Silver, 42 | 1 | 1 | 1 | 1 |
| LL Mountain Frame - Silver, 48 | 1 | 1 | 1 | 1 |
| LL Mountain Front Wheel | 1 | 1 | 1 | 1 |
| LL Mountain Pedal | 1 | 1 | 1 | 1 |
| LL Mountain Rim | 1 | 1 | 1 | 1 |
| LL Mountain Seat/Saddle | 1 | 1 | 1 | 1 |
| LL Nipple | 1 | 1 | 1 | 1 |
| LL Road Frame - Black, 48 | 1 | 1 | 1 | 1 |
| LL Road Frame - Black, 58 | 1 | 1 | 1 | 1 |
| LL Road Frame - Black, 62 | 1 | 1 | 1 | 1 |
| LL Road Frame - Red, 48 | 1 | 1 | 1 | 1 |
| LL Road Frame - Red, 62 | 3 | 1 | 3 | 1 |
| LL Road Handlebars | 1 | 1 | 1 | 1 |
| LL Road Rear Wheel | 1 | 1 | 1 | 1 |
| LL Road Seat Assembly | 1 | 1 | 1 | 1 |
| LL Spindle/Axle | 3 | 1 | 3 | 1 |
| LL Touring Frame - Blue, 58 | 3 | 1 | 3 | 1 |
| LL Touring Frame - Yellow, 54 | 3 | 1 | 3 | 1 |
| LL Touring Frame - Yellow, 62 | 1 | 1 | 1 | 1 |
| LL Touring Seat Assembly | 1 | 1 | 1 | 1 |
| Lock Nut 11 | 3 | 1 | 3 | 1 |
| Lock Nut 15 | 3 | 1 | 3 | 1 |
| Lock Nut 19 | 3 | 1 | 3 | 1 |
| Lock Nut 22 | 3 | 1 | 3 | 1 |
| Lock Nut 5 | 3 | 1 | 3 | 1 |
| Lock Nut 7 | 1 | 1 | 1 | 1 |
| Lock Nut 9 | 1 | 1 | 1 | 1 |
| Lock Washer 11 | 3 | 1 | 3 | 1 |
| Lock Washer 13 | 1 | 1 | 1 | 1 |
| Lock Washer 5 | 3 | 1 | 3 | 1 |
| Lock Washer 7 | 1 | 1 | 1 | 1 |
| Lock Washer 9 | 1 | 1 | 1 | 1 |
| Long-Sleeve Logo Jersey, M | 1 | 1 | 1 | 1 |
| Long-Sleeve Logo Jersey, XL | 1 | 1 | 1 | 1 |
| Men's Bib-Shorts, L | 1 | 1 | 1 | 1 |
| Men's Bib-Shorts, S | 1 | 1 | 1 | 1 |
| Men's Sports Shorts, XL | 3 | 1 | 3 | 1 |
| Metal Bar 1 | 1 | 1 | 1 | 1 |
| Metal Plate 1 | 1 | 1 | 1 | 1 |
| Metal Plate 3 | 1 | 1 | 1 | 1 |
| Metal Sheet 2 | 1 | 1 | 1 | 1 |
| Metal Sheet 4 | 1 | 1 | 1 | 1 |
| Metal Sheet 6 | 1 | 1 | 1 | 1 |
| Metal Tread Plate | 1 | 1 | 1 | 1 |
| ML Bottom Bracket | 1 | 1 | 1 | 1 |
| ML Crankset | 1 | 1 | 1 | 1 |
| ML Grip Tape | 1 | 1 | 1 | 1 |
| ML Mountain Frame - Black, 38 | 1 | 1 | 1 | 1 |
| ML Mountain Frame - Black, 44 | 1 | 1 | 1 | 1 |
| ML Mountain Frame-W - Silver, 38 | 1 | 1 | 1 | 1 |
| ML Mountain Frame-W - Silver, 42 | 1 | 1 | 1 | 1 |
| ML Mountain Front Wheel | 1 | 1 | 1 | 1 |
| ML Mountain Pedal | 1 | 1 | 1 | 1 |
| ML Mountain Rim | 1 | 1 | 1 | 1 |
| ML Mountain Seat/Saddle | 1 | 1 | 1 | 1 |
| ML Road Frame - Red, 44 | 1 | 1 | 1 | 1 |
| ML Road Frame - Red, 52 | 1 | 1 | 1 | 1 |
| ML Road Frame - Red, 60 | 1 | 1 | 1 | 1 |
| ML Road Frame-W - Yellow, 40 | 1 | 1 | 1 | 1 |
| ML Road Frame-W - Yellow, 44 | 1 | 1 | 1 | 1 |
| ML Road Front Wheel | 1 | 1 | 1 | 1 |
| ML Road Pedal | 1 | 1 | 1 | 1 |
| ML Road Rim | 1 | 1 | 1 | 1 |
| ML Road Seat/Saddle | 1 | 1 | 1 | 1 |
| ML Touring Seat Assembly | 1 | 1 | 1 | 1 |
| Mountain Bike Socks, L | 1 | 1 | 1 | 1 |
| Mountain Bottle Cage | 1 | 1 | 1 | 1 |
| Mountain-100 Black, 38 | 3 | 1 | 3 | 1 |
| Mountain-100 Black, 44 | 1 | 1 | 1 | 1 |
| Mountain-100 Silver, 38 | 1 | 1 | 1 | 1 |
| Mountain-100 Silver, 44 | 1 | 1 | 1 | 1 |
| Mountain-200 Black, 38 | 1 | 1 | 1 | 1 |
| Mountain-200 Black, 46 | 1 | 1 | 1 | 1 |
| Mountain-200 Silver, 42 | 1 | 1 | 1 | 1 |
| Mountain-300 Black, 38 | 1 | 1 | 1 | 1 |
| Mountain-400-W Silver, 38 | 3 | 1 | 3 | 1 |
| Mountain-400-W Silver, 42 | 1 | 1 | 1 | 1 |
| Mountain-500 Black, 40 | 1 | 1 | 1 | 1 |
| Mountain-500 Black, 44 | 1 | 1 | 1 | 1 |
| Mountain-500 Black, 52 | 1 | 1 | 1 | 1 |
| Mountain-500 Silver, 42 | 1 | 1 | 1 | 1 |
| Mountain-500 Silver, 48 | 1 | 1 | 1 | 1 |
| Paint - Black | 1 | 1 | 1 | 1 |
| Paint - Red | 1 | 1 | 1 | 1 |
| Paint - Yellow | 1 | 1 | 1 | 1 |
| Pinch Bolt | 1 | 1 | 1 | 1 |
| Racing Socks, M | 1 | 1 | 1 | 1 |
| Rear Derailleur | 1 | 1 | 1 | 1 |
| Reflector | 1 | 1 | 1 | 1 |
| Road End Caps | 1 | 1 | 1 | 1 |
| Road-150 Red, 44 | 1 | 1 | 1 | 1 |
| Road-150 Red, 52 | 1 | 1 | 1 | 1 |
| Road-150 Red, 62 | 1 | 1 | 1 | 1 |
| Road-250 Black, 48 | 1 | 1 | 1 | 1 |
| Road-250 Black, 58 | 1 | 1 | 1 | 1 |
| Road-250 Red, 48 | 1 | 1 | 1 | 1 |
| Road-250 Red, 58 | 1 | 1 | 1 | 1 |
| Road-350-W Yellow, 42 | 1 | 1 | 1 | 1 |
| Road-350-W Yellow, 48 | 1 | 1 | 1 | 1 |
| Road-450 Red, 48 | 1 | 1 | 1 | 1 |
| Road-450 Red, 58 | 1 | 1 | 1 | 1 |
| Road-550-W Yellow, 38 | 1 | 1 | 1 | 1 |
| Road-550-W Yellow, 44 | 2 | 1 | 2 | 1 |
| Road-650 Black, 52 | 3 | 1 | 3 | 1 |
| Road-650 Red, 44 | 3 | 1 | 3 | 1 |
| Road-650 Red, 60 | 3 | 1 | 3 | 1 |
| Road-750 Black, 52 | 3 | 1 | 3 | 1 |
| Seat Stays | 3 | 1 | 3 | 1 |
| Short-Sleeve Classic Jersey, S | 3 | 1 | 3 | 1 |
| Sport-100 Helmet, Blue | 3 | 1 | 3 | 1 |
| Taillights - Battery-Powered | 3 | 1 | 3 | 1 |
| Thin-Jam Hex Nut 11 | 3 | 1 | 3 | 1 |
| Thin-Jam Hex Nut 15 | 3 | 1 | 3 | 1 |
| Thin-Jam Hex Nut 4 | 3 | 1 | 3 | 1 |
| Thin-Jam Hex Nut 8 | 3 | 1 | 3 | 1 |
| Thin-Jam Lock Nut 11 | 3 | 1 | 3 | 1 |
| Thin-Jam Lock Nut 15 | 3 | 1 | 3 | 1 |
| Thin-Jam Lock Nut 4 | 3 | 1 | 3 | 1 |
| Thin-Jam Lock Nut 8 | 3 | 1 | 3 | 1 |
| Touring Front Wheel | 3 | 1 | 3 | 1 |
| Touring Tire | 3 | 1 | 3 | 1 |
| Touring-1000 Blue, 54 | 3 | 1 | 3 | 1 |
| Touring-1000 Yellow, 54 | 3 | 1 | 3 | 1 |
| Touring-2000 Blue, 54 | 3 | 1 | 3 | 1 |
| Touring-3000 Blue, 54 | 3 | 1 | 3 | 1 |
| Touring-3000 Yellow, 50 | 3 | 1 | 3 | 1 |
| Touring-Panniers, Large | 3 | 1 | 3 | 1 |
| Women's Mountain Shorts, S | 3 | 1 | 3 | 1 |
| Women's Tights, S | 2 | 1 | 2 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Product_rowguid | Aug 8 2010 5:23PM | 504 | 504 | 190 | 1 | 20 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001984127 | 16 | rowguid |
| 0.001984127 | 20 | rowguid, ProductID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 7a927632-99a4-4f24-adce-0062d2d113d9 | 0 | 1 | 0 | 1 |
| 89b6e84f-5c08-4cd9-b803-01f2ce24e417 | 2 | 1 | 2 | 1 |
| 9e66de78-decb-438a-b9a9-023c773c60a2 | 1 | 1 | 1 | 1 |
| f246acaa-a80b-40ec-9208-02edef885129 | 1 | 1 | 1 | 1 |
| 906d42f6-c21f-4d20-b528-02ffdb55fd1e | 1 | 1 | 1 | 1 |
| 85b9a3de-000c-4351-9494-05796689c216 | 1 | 1 | 1 | 1 |
| c9fd1df4-9512-420a-b379-067108033b75 | 1 | 1 | 1 | 1 |
| 20799030-420c-496a-9922-09189c2b457e | 5 | 1 | 5 | 1 |
| 49845afe-a8cc-4354-a5d4-09d35bf7fb9e | 1 | 1 | 1 | 1 |
| d3a7a02c-a3d5-4a04-9454-0c4e43772b78 | 1 | 1 | 1 | 1 |
| 955811b4-2f17-48f0-a8b4-0c96cba4aa6d | 1 | 1 | 1 | 1 |
| b2508cf2-c64f-493d-9db4-0d6601af1f73 | 1 | 1 | 1 | 1 |
| 639d8448-b427-47b1-9e5b-0e5090a27632 | 1 | 1 | 1 | 1 |
| 0c02f2cc-bdb4-4794-a4f9-0eb33f7545c2 | 1 | 1 | 1 | 1 |
| bbbf003b-367d-4d71-af71-10f50b6234a0 | 3 | 1 | 3 | 1 |
| eb10b88c-5351-4c06-af51-116baa48a2c8 | 3 | 1 | 3 | 1 |
| a1ae0c6d-92a5-4fda-b33b-1301e83efe5b | 1 | 1 | 1 | 1 |
| f5752c9c-56ba-41a7-83fd-139da28c15fa | 1 | 1 | 1 | 1 |
| f70bbecd-5be7-4ee9-a9e7-15786e622ba9 | 1 | 1 | 1 | 1 |
| b181ec1f-ca20-4724-b2eb-15f3e455142e | 1 | 1 | 1 | 1 |
| 9e18adab-b9c7-45b1-bd95-1805ec4f297d | 1 | 1 | 1 | 1 |
| 30819b88-f0d3-4e7a-8105-19f6fac2cefb | 1 | 1 | 1 | 1 |
| e2f03586-02e8-4cd9-a342-1a8d65d393bd | 1 | 1 | 1 | 1 |
| acdae407-b40e-435e-8e84-1bfc33013e81 | 3 | 1 | 3 | 1 |
| 874c800e-334d-4a3c-8d3a-1e872d5b2a1b | 1 | 1 | 1 | 1 |
| d864879a-e8b1-4f7b-bafa-1f136089c2c8 | 1 | 1 | 1 | 1 |
| ccd4fa47-7194-4bd0-909b-1fa4bd7916a7 | 1 | 1 | 1 | 1 |
| 6ec47ec9-c041-4dda-b686-2125d539ce9b | 3 | 1 | 3 | 1 |
| 92dc4ba8-a052-45df-83ec-226f050f876b | 3 | 1 | 3 | 1 |
| 5646c15a-68ad-4234-b328-254706cbccc5 | 3 | 1 | 3 | 1 |
| b2cc7dfb-783d-4587-88c0-2712a538a5b2 | 1 | 1 | 1 | 1 |
| efc09cdb-ecd5-4db5-9e27-277dda6d7f50 | 1 | 1 | 1 | 1 |
| d2bd1f55-2cd4-4998-89fa-28ff2e28de2c | 1 | 1 | 1 | 1 |
| 601b1fe8-d4d0-4cfb-9379-29481cc05291 | 1 | 1 | 1 | 1 |
| 0a72791c-a984-4733-ae4e-2b4373cfd7cd | 1 | 1 | 1 | 1 |
| 6070b1ea-59b7-4f8b-950f-2be07d00449d | 1 | 1 | 1 | 1 |
| 76fac097-1fb3-456b-8fb9-2c7a613771b4 | 1 | 1 | 1 | 1 |
| 34b08c1f-99d1-43c4-8ef7-2cd754b6665d | 1 | 1 | 1 | 1 |
| a88f15be-2719-4741-93a4-2d96ef3712eb | 1 | 1 | 1 | 1 |
| a56851f9-1cd7-4e2f-8779-2e773e1b5209 | 1 | 1 | 1 | 1 |
| 6a290063-a0cf-432a-8110-2ea0fda14308 | 1 | 1 | 1 | 1 |
| 0ae4ce60-5242-48f5-ada1-3013ff45f969 | 1 | 1 | 1 | 1 |
| fa81e47d-7333-49c2-809b-308171ca2fb1 | 1 | 1 | 1 | 1 |
| 5ec991ad-8761-4a61-a318-312df3a78604 | 1 | 1 | 1 | 1 |
| 179fec38-cab5-4a47-bcff-31cfc9e43a3c | 1 | 1 | 1 | 1 |
| 2140f256-f705-4d67-975d-32de03265838 | 1 | 1 | 1 | 1 |
| 22616fd2-b99f-4f7d-acf6-33dff66d42d2 | 1 | 1 | 1 | 1 |
| 0aa71ad6-afaf-43c6-9745-35d815b50a5b | 1 | 1 | 1 | 1 |
| 285fd682-c647-49d1-b8f3-368a43c9cda0 | 1 | 1 | 1 | 1 |
| 4852db13-308a-4893-aafa-390a0dfe9f12 | 1 | 1 | 1 | 1 |
| 9fdd0c65-b2b0-4c6c-8704-3a9747be5174 | 1 | 1 | 1 | 1 |
| acbb1de1-680c-4034-a8c5-3c6b01e57aa7 | 1 | 1 | 1 | 1 |
| 32c97696-7c3d-4793-a54b-3d73200badbc | 1 | 1 | 1 | 1 |
| e9aae947-6bc3-4909-8937-3e1cdcec8a8f | 1 | 1 | 1 | 1 |
| ec2e54f5-9d07-4c26-b969-40f835395be3 | 3 | 1 | 3 | 1 |
| a35a1c35-c128-4697-951e-4199062e78f3 | 3 | 1 | 3 | 1 |
| 6903ce24-d0ce-4191-9198-4231de37a929 | 3 | 1 | 3 | 1 |
| 4f638e15-2ed0-4193-90ce-47da580e01dd | 3 | 1 | 3 | 1 |
| 968e3610-e583-42e8-8ab6-484a799b1774 | 3 | 1 | 3 | 1 |
| 9f60af1e-4c11-4e90-baea-48e834e8b4c2 | 1 | 1 | 1 | 1 |
| 7d4bad17-374f-4281-9ae5-49abc3fe585d | 1 | 1 | 1 | 1 |
| 1173306e-b616-4c4a-b715-4e0a483ba2b5 | 3 | 1 | 3 | 1 |
| c1813164-1b4b-42d1-9007-4e5f9aee0e19 | 1 | 1 | 1 | 1 |
| 1ff419b5-52af-4f7e-aeae-4fec5e99de35 | 3 | 1 | 3 | 1 |
| ad109395-fda9-4c2a-96f1-515ccde3d9f4 | 1 | 1 | 1 | 1 |
| 799a56ff-5ad2-41b3-bfac-528b477ad129 | 1 | 1 | 1 | 1 |
| fa710215-925f-4959-81df-538e72a6a255 | 1 | 1 | 1 | 1 |
| fa3c65cd-0a22-47e3-bdf6-53f1dc138c43 | 1 | 1 | 1 | 1 |
| c19e1136-5da4-4b40-8758-54a85d7ea494 | 1 | 1 | 1 | 1 |
| 6ce0661d-ba1f-4012-b785-55165b3b241a | 1 | 1 | 1 | 1 |
| 2d9f59b8-9f24-46eb-98ad-553e48bb9db9 | 1 | 1 | 1 | 1 |
| 109cb7bc-6ec6-4a36-85c8-55b843b2ab12 | 1 | 1 | 1 | 1 |
| f2f3a14c-df15-4957-966d-55e5fcad1161 | 1 | 1 | 1 | 1 |
| b8d1b5d9-8a39-4097-a04a-56e95559b534 | 1 | 1 | 1 | 1 |
| 4f040109-8332-4fcf-8084-57e6d8c49283 | 1 | 1 | 1 | 1 |
| d4a2fcad-1e63-4ebd-863c-5a7c48d5b8d9 | 1 | 1 | 1 | 1 |
| 8ae32663-8d6f-457d-8343-5b181fec43a7 | 1 | 1 | 1 | 1 |
| c49679bd-96a9-4176-a7ed-5bc6d6444647 | 1 | 1 | 1 | 1 |
| 09343e22-2494-4279-9f32-5d961a0fbfea | 1 | 1 | 1 | 1 |
| 40d5effa-c0c4-479f-af66-5f1bf8ed3bfb | 3 | 1 | 3 | 1 |
| cb524e92-4fa8-4f6c-9993-60796856c654 | 1 | 1 | 1 | 1 |
| 84a3473e-ae26-4a21-81b9-60bb418a79b2 | 1 | 1 | 1 | 1 |
| 53ad147d-c16d-4a8c-b086-625a31405574 | 1 | 1 | 1 | 1 |
| 23d89cee-9f44-4f3e-b289-63de6ba2b737 | 3 | 1 | 3 | 1 |
| d28b3872-5173-40a4-b12f-655524386cc7 | 3 | 1 | 3 | 1 |
| f0ac2c4d-1a1f-4e3c-b4d9-68aea0ec1ce4 | 3 | 1 | 3 | 1 |
| 2c4a8956-7b72-48fe-b028-699e117b1daa | 1 | 1 | 1 | 1 |
| 4ea4fe06-aaea-42d4-a9d9-69f6a9a4a042 | 1 | 1 | 1 | 1 |
| 88a7b897-6ff5-4ca2-b68a-6ea0e86f92b9 | 7 | 1 | 7 | 1 |
| 27db28f8-5ab8-4091-b94e-6f1b2d8e7ab0 | 3 | 1 | 3 | 1 |
| 756f862e-40cc-4dfc-b189-716d0dda5ff9 | 3 | 1 | 3 | 1 |
| ae7bcda7-e836-4f68-9e61-745f27f9aa3e | 3 | 1 | 3 | 1 |
| bbfff5a5-4bdc-49a9-a5ad-7584adffe808 | 1 | 1 | 1 | 1 |
| 23b5d52b-8c29-4059-b899-75c53b5ee2e6 | 1 | 1 | 1 | 1 |
| bb6bd7b3-a34d-4d64-822e-781fa6838e19 | 3 | 1 | 3 | 1 |
| 71ab847f-d091-42d6-b735-7b0c2d82fc84 | 5 | 1 | 5 | 1 |
| 5d17ff1c-f50e-438f-a4e9-7c400fb762e7 | 1 | 1 | 1 | 1 |
| c455e0b3-d716-419d-abf0-7e03efdd2e26 | 1 | 1 | 1 | 1 |
| 274c86dc-439e-4469-9de8-7e9bd6455d0d | 1 | 1 | 1 | 1 |
| 12b1f317-c39b-48d0-b1a7-8018c60aea53 | 1 | 1 | 1 | 1 |
| 43024784-2741-4cab-a6dc-8050ce507f2e | 1 | 1 | 1 | 1 |
| 459e041c-3234-409e-b4cd-81728f8a2398 | 1 | 1 | 1 | 1 |
| ee76fae0-161e-409c-a6f5-837b5b8b344d | 3 | 1 | 3 | 1 |
| 2c1c58b4-234c-4b3a-8c8e-84524ac05eea | 1 | 1 | 1 | 1 |
| 448e9e7b-9548-4a4c-abb3-853686aa7517 | 1 | 1 | 1 | 1 |
| 37bd4d2b-346b-4c6b-8f3f-85c084282529 | 1 | 1 | 1 | 1 |
| 8bb96dfb-23aa-4877-9c5e-866bb18facc7 | 1 | 1 | 1 | 1 |
| a05464e8-6b4d-42b3-a4d6-8683136f4b66 | 1 | 1 | 1 | 1 |
| 344ad07c-cca5-4374-a3f3-8a7e0a1d9916 | 1 | 1 | 1 | 1 |
| 612c26c7-6018-4050-b628-8b2d2e6841fa | 3 | 1 | 3 | 1 |
| 2b2a5641-bffe-4079-b9f0-8bf355bc3996 | 1 | 1 | 1 | 1 |
| 433ee702-e028-4630-895c-8cdbd0f1fd89 | 1 | 1 | 1 | 1 |
| 9d5ca300-5302-41e1-bca5-8ce5b93f26a5 | 1 | 1 | 1 | 1 |
| 8c471bca-a735-4087-ad50-90ede0ac1a1b | 1 | 1 | 1 | 1 |
| 6ea94fbf-b9aa-43fc-84e8-91d508dde751 | 1 | 1 | 1 | 1 |
| 7da2613b-3347-4072-a1dc-943ada161d7f | 3 | 1 | 3 | 1 |
| c72c9978-0b04-46b3-9de6-948feca1c86e | 1 | 1 | 1 | 1 |
| f230baac-5951-4eb1-b1e8-94c2ca2b37fa | 1 | 1 | 1 | 1 |
| 1cbfa85b-5c9b-4b58-9c17-95238215d926 | 1 | 1 | 1 | 1 |
| aeca59da-b61c-4976-8316-97e14cd4eff1 | 1 | 1 | 1 | 1 |
| a3ee3bc5-73c5-45f3-a952-9991d038dd9c | 1 | 1 | 1 | 1 |
| ce4849b4-56e6-4b50-808b-9bde67cc4704 | 3 | 1 | 3 | 1 |
| d7b1d161-182e-44f6-a9ff-9c1eba76613b | 1 | 1 | 1 | 1 |
| 64844011-a1c3-4f8f-9caa-9c8d214ecc12 | 1 | 1 | 1 | 1 |
| b2f7cf9b-a7bf-49ab-9cca-9f6e791cd693 | 1 | 1 | 1 | 1 |
| 0a7ad37c-3696-4844-8633-9fddcd5fcefc | 1 | 1 | 1 | 1 |
| 93f7bc73-bd22-45a0-9f2e-a11932342e6b | 1 | 1 | 1 | 1 |
| 35e28755-e8f0-47be-a8be-a20836dbe28d | 1 | 1 | 1 | 1 |
| 5247be33-50bf-4527-8a30-a39aae500a8e | 1 | 1 | 1 | 1 |
| 76060a93-949c-48ea-9b31-a593d6c14983 | 1 | 1 | 1 | 1 |
| 4a898b1e-9a3b-4beb-9873-a7465934051a | 3 | 1 | 3 | 1 |
| dd70cf36-449a-43fd-839d-a84ee14c849a | 1 | 1 | 1 | 1 |
| a0da8f8f-45fb-4e62-ab14-aa229087de1e | 1 | 1 | 1 | 1 |
| db37b435-74b9-43d3-b363-abbead107bc4 | 1 | 1 | 1 | 1 |
| d583d825-c707-4529-b6f2-abffa21b81ec | 1 | 1 | 1 | 1 |
| a57b7915-2e65-49de-87ba-acd007c55adb | 1 | 1 | 1 | 1 |
| 1a66b244-5ca0-4153-b539-ae048d14faec | 1 | 1 | 1 | 1 |
| 6711d6bc-664f-4890-9f69-af1de321d055 | 1 | 1 | 1 | 1 |
| 1084221e-1890-443e-9d87-afcad6358355 | 3 | 1 | 3 | 1 |
| 1c530fe8-a169-4adc-b3dc-b11a48245e63 | 1 | 1 | 1 | 1 |
| 8dfef6f2-91a8-4884-8949-b2551218b37a | 1 | 1 | 1 | 1 |
| 05b2e20f-2399-4cb3-9b49-b28d6649c104 | 1 | 1 | 1 | 1 |
| 84abda8f-0007-4bca-9a61-b2dea58866c3 | 1 | 1 | 1 | 1 |
| 3050e4df-2bba-4c2b-bdcc-b4c89972db1c | 1 | 1 | 1 | 1 |
| 33f42284-e216-4b98-ba48-b4ee18a01fa0 | 1 | 1 | 1 | 1 |
| 9fa4a3b5-d396-48d4-adfc-b573bc4a800a | 1 | 1 | 1 | 1 |
| 0d879312-a7d3-441d-9d23-b6550bab3814 | 1 | 1 | 1 | 1 |
| f1168c45-e4d2-4c37-adad-b76eaf402b71 | 1 | 1 | 1 | 1 |
| e876e239-7ec2-45c8-ba4b-b9ceacb379a6 | 1 | 1 | 1 | 1 |
| 22976fa7-0ad0-40f9-b4f9-ba10279ea1a3 | 1 | 1 | 1 | 1 |
| fcfea68f-310e-4e6e-9f99-bb17d011ebae | 1 | 1 | 1 | 1 |
| a96a5024-87de-488a-bf81-bc0c81f6cd18 | 1 | 1 | 1 | 1 |
| 02c48826-21ad-41f3-85a6-bc9a85a4dce4 | 3 | 1 | 3 | 1 |
| b96c057b-6416-4851-8d59-bcb37c8e6e51 | 1 | 1 | 1 | 1 |
| c9967889-f490-4a66-943a-bce432e938d8 | 1 | 1 | 1 | 1 |
| 02935111-a546-4c6d-941f-be12d42c158e | 1 | 1 | 1 | 1 |
| 28287157-3f06-487b-8531-bee8a37329e4 | 1 | 1 | 1 | 1 |
| e9c17be7-f4dc-465e-ab73-c0198f37bfdd | 1 | 1 | 1 | 1 |
| 3c9d10b7-a6b2-4774-9963-c19dcee72fea | 1 | 1 | 1 | 1 |
| cf739f9a-0af0-4810-b229-c431a31d7779 | 3 | 1 | 3 | 1 |
| a99d90c0-05e2-4e44-ad90-c55c9f0784de | 1 | 1 | 1 | 1 |
| f1bb3957-8d27-47f3-91ec-c71822d11436 | 1 | 1 | 1 | 1 |
| df85e805-af87-4fab-a668-c80f2a5b8a69 | 1 | 1 | 1 | 1 |
| 35213547-275f-4767-805d-c8a4b8e13745 | 2 | 1 | 2 | 1 |
| 44ce4802-409f-43ab-9b27-ca53421805be | 3 | 1 | 3 | 1 |
| 18f95f47-1540-4e02-8f1f-cc1bcb6828d0 | 3 | 1 | 3 | 1 |
| df4ce1e2-ba9a-4657-b999-ccfa6c55d9c1 | 3 | 1 | 3 | 1 |
| a0fad492-ac24-4fcf-8d2a-d21d06386ae1 | 3 | 1 | 3 | 1 |
| 590c2c3f-a8b6-42b5-9412-d655e37f0eae | 3 | 1 | 3 | 1 |
| 694215b7-08f7-4c0d-acb1-d734ba44c0c8 | 3 | 1 | 3 | 1 |
| 20c2c611-dffc-49b5-99cf-d89bdd3a91ce | 3 | 1 | 3 | 1 |
| 51a32ca6-65a1-4c31-af2b-d9e4f5d631d4 | 3 | 1 | 3 | 1 |
| 9a751f85-7130-4562-9f22-db9cab6e5bbc | 3 | 1 | 3 | 1 |
| d182cf18-4ddf-429b-a0df-de1cfc92622d | 3 | 1 | 3 | 1 |
| aad81532-a572-49a5-83c3-dfa9e3b4fea6 | 3 | 1 | 3 | 1 |
| 7920bc3b-8fd4-4610-93d2-e693a66b6474 | 7 | 1 | 7 | 1 |
| 30d2254d-e26d-4586-b4c5-e8ccb8a059b8 | 3 | 1 | 3 | 1 |
| e33e8c4c-282a-4d1f-91e7-e9969cf7134f | 3 | 1 | 3 | 1 |
| b478b33a-1fd5-4db6-b99a-eb3b2a7c1623 | 3 | 1 | 3 | 1 |
| df629c11-8d8b-4774-9d52-ecb64dc95212 | 3 | 1 | 3 | 1 |
| 33fa1a03-38d6-405e-be9b-eea92f3d204f | 3 | 1 | 3 | 1 |
| daff9e11-6254-432d-8c4f-f06e52687184 | 3 | 1 | 3 | 1 |
| 75752e26-a3b6-4264-9b06-f23a4fbdc5a7 | 3 | 1 | 3 | 1 |
| 2c7dd8c3-4c55-475f-ba58-f4baca520d72 | 3 | 1 | 3 | 1 |
| 2536e3b2-d4da-49e6-965a-f612c2c8914f | 3 | 1 | 3 | 1 |
| b59b7bf2-7afc-4a74-b063-f942f1e0da19 | 3 | 1 | 3 | 1 |
| f06c2cbf-0901-4c08-80ed-fb4e87171b3b | 3 | 1 | 3 | 1 |
| 5bcc4558-6c16-48f1-92f0-fd2eefb17306 | 3 | 1 | 3 | 1 |
| 57169f80-fafb-4678-8f51-fe1f131d0c83 | 1 | 1 | 1 | 1 |
| b9ede243-a6f4-4629-b1d4-ffe1aedc6de7 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000013_66603565 | Aug 8 2010 5:23PM | 504 | 504 | 33 | 0.5555556 | 2.34127 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.02631579 | 2.34127 | ProductSubcategoryID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 209 | 0 | 1 | |
| 1 | 0 | 32 | 0 | 1 |
| 2 | 0 | 43 | 0 | 1 |
| 3 | 0 | 22 | 0 | 1 |
| 4 | 0 | 8 | 0 | 1 |
| 5 | 0 | 3 | 0 | 1 |
| 6 | 0 | 2 | 0 | 1 |
| 7 | 0 | 1 | 0 | 1 |
| 8 | 0 | 3 | 0 | 1 |
| 9 | 0 | 2 | 0 | 1 |
| 11 | 3 | 3 | 1 | 3 |
| 12 | 0 | 28 | 0 | 1 |
| 13 | 0 | 7 | 0 | 1 |
| 14 | 0 | 33 | 0 | 1 |
| 15 | 0 | 9 | 0 | 1 |
| 16 | 0 | 18 | 0 | 1 |
| 17 | 0 | 14 | 0 | 1 |
| 18 | 0 | 3 | 0 | 1 |
| 19 | 0 | 1 | 0 | 1 |
| 20 | 0 | 6 | 0 | 1 |
| 21 | 0 | 8 | 0 | 1 |
| 22 | 0 | 7 | 0 | 1 |
| 23 | 0 | 4 | 0 | 1 |
| 25 | 3 | 3 | 1 | 3 |
| 27 | 1 | 1 | 1 | 1 |
| 28 | 0 | 3 | 0 | 1 |
| 30 | 1 | 1 | 1 | 1 |
| 31 | 0 | 3 | 0 | 1 |
| 32 | 0 | 1 | 0 | 1 |
| 33 | 0 | 3 | 0 | 1 |
| 35 | 1 | 1 | 1 | 1 |
| 36 | 0 | 2 | 0 | 1 |
| 37 | 0 | 11 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000014_66603565 | Aug 8 2010 5:23PM | 504 | 504 | 75 | 0.7142857 | 2.34127 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.008333334 | 2.34127 | ProductModelID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 209 | 0 | 1 | |
| 1 | 0 | 3 | 0 | 1 |
| 2 | 0 | 1 | 0 | 1 |
| 4 | 3 | 3 | 1 | 3 |
| 5 | 0 | 10 | 0 | 1 |
| 6 | 0 | 11 | 0 | 1 |
| 7 | 0 | 8 | 0 | 1 |
| 8 | 0 | 10 | 0 | 1 |
| 9 | 0 | 12 | 0 | 1 |
| 10 | 0 | 10 | 0 | 1 |
| 11 | 0 | 4 | 0 | 1 |
| 12 | 0 | 3 | 0 | 1 |
| 13 | 0 | 4 | 0 | 1 |
| 14 | 0 | 3 | 0 | 1 |
| 16 | 5 | 5 | 1 | 5 |
| 17 | 0 | 5 | 0 | 1 |
| 18 | 0 | 2 | 0 | 1 |
| 19 | 0 | 8 | 0 | 1 |
| 20 | 0 | 6 | 0 | 1 |
| 22 | 4 | 4 | 1 | 4 |
| 23 | 0 | 10 | 0 | 1 |
| 24 | 0 | 2 | 0 | 1 |
| 25 | 0 | 5 | 0 | 1 |
| 26 | 0 | 8 | 0 | 1 |
| 27 | 0 | 4 | 0 | 1 |
| 29 | 5 | 5 | 1 | 5 |
| 30 | 0 | 12 | 0 | 1 |
| 32 | 4 | 4 | 1 | 4 |
| 33 | 0 | 3 | 0 | 1 |
| 34 | 0 | 8 | 0 | 1 |
| 35 | 0 | 4 | 0 | 1 |
| 36 | 0 | 10 | 0 | 1 |
| 38 | 3 | 3 | 1 | 3 |
| 42 | 0 | 1 | 0 | 1 |
| 44 | 1 | 1 | 1 | 1 |
| 46 | 1 | 1 | 1 | 1 |
| 48 | 1 | 1 | 1 | 1 |
| 50 | 1 | 1 | 1 | 1 |
| 52 | 1 | 1 | 1 | 1 |
| 54 | 1 | 1 | 1 | 1 |
| 56 | 1 | 1 | 1 | 1 |
| 58 | 1 | 1 | 1 | 1 |
| 60 | 1 | 1 | 1 | 1 |
| 62 | 1 | 1 | 1 | 1 |
| 64 | 1 | 1 | 1 | 1 |
| 66 | 1 | 1 | 1 | 1 |
| 68 | 1 | 1 | 1 | 1 |
| 70 | 1 | 1 | 1 | 1 |
| 77 | 0 | 1 | 0 | 1 |
| 79 | 1 | 1 | 1 | 1 |
| 81 | 1 | 1 | 1 | 1 |
| 83 | 1 | 1 | 1 | 1 |
| 85 | 1 | 1 | 1 | 1 |
| 87 | 1 | 1 | 1 | 1 |
| 89 | 1 | 1 | 1 | 1 |
| 91 | 1 | 1 | 1 | 1 |
| 93 | 1 | 1 | 1 | 1 |
| 95 | 1 | 1 | 1 | 1 |
| 97 | 1 | 1 | 1 | 1 |
| 99 | 1 | 1 | 1 | 1 |
| 101 | 1 | 1 | 1 | 1 |
| 103 | 1 | 1 | 1 | 1 |
| 105 | 1 | 1 | 1 | 1 |
| 107 | 1 | 1 | 1 | 1 |
| 109 | 1 | 1 | 1 | 1 |
| 111 | 1 | 1 | 1 | 1 |
| 113 | 1 | 1 | 1 | 1 |
| 115 | 1 | 1 | 1 | 1 |
| 117 | 1 | 1 | 1 | 1 |
| 119 | 1 | 1 | 1 | 1 |
| 121 | 1 | 1 | 1 | 1 |
| 123 | 1 | 1 | 1 | 1 |
| 125 | 1 | 1 | 1 | 1 |
| 127 | 1 | 1 | 1 | 1 |
| 128 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000D_66603565 | Aug 8 2010 5:23PM | 504 | 504 | 3 | 0 | 2.440476 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.3333333 | 2.440476 | WeightUnitMeasureCode |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 299 | 0 | 1 | |
| G | 0 | 29 | 0 | 1 |
| LB | 0 | 176 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000C_66603565 | Aug 8 2010 5:23PM | 504 | 504 | 2 | 0 | 2.095238 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.5 | 2.095238 | SizeUnitMeasureCode |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 328 | 0 | 1 | |
| CM | 0 | 176 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000A_66603565 | Oct 3 2011 2:28PM | 504 | 504 | 100 | 0.25 | 8 |
|
504 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.009708738 | 8 | ListPrice |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0.0000 | 0 | 200 | 0 | 1 |
| 2.2900 | 0 | 1 | 0 | 1 |
| 3.9900 | 0 | 1 | 0 | 1 |
| 4.9900 | 0 | 3 | 0 | 1 |
| 7.9500 | 0 | 1 | 0 | 1 |
| 8.9900 | 0 | 4 | 0 | 1 |
| 9.5000 | 0 | 2 | 0 | 1 |
| 9.9900 | 0 | 1 | 0 | 1 |
| 13.9900 | 0 | 1 | 0 | 1 |
| 19.9900 | 0 | 1 | 0 | 1 |
| 20.2400 | 0 | 1 | 0 | 1 |
| 21.4900 | 0 | 1 | 0 | 1 |
| 21.9800 | 0 | 1 | 0 | 1 |
| 24.4900 | 0 | 3 | 0 | 1 |
| 24.9900 | 0 | 3 | 0 | 1 |
| 25.0000 | 0 | 1 | 0 | 1 |
| 27.1200 | 0 | 3 | 0 | 1 |
| 28.9900 | 0 | 1 | 0 | 1 |
| 29.9900 | 0 | 1 | 0 | 1 |
| 32.6000 | 0 | 1 | 0 | 1 |
| 34.2000 | 0 | 1 | 0 | 1 |
| 34.9900 | 0 | 4 | 0 | 1 |
| 35.0000 | 0 | 1 | 0 | 1 |
| 37.9900 | 0 | 3 | 0 | 1 |
| 39.1400 | 0 | 3 | 0 | 1 |
| 40.4900 | 0 | 2 | 0 | 1 |
| 44.5400 | 0 | 2 | 0 | 1 |
| 44.9900 | 0 | 1 | 0 | 1 |
| 46.0900 | 0 | 1 | 0 | 1 |
| 49.9900 | 0 | 4 | 0 | 1 |
| 52.6400 | 0 | 3 | 0 | 1 |
| 53.9900 | 0 | 5 | 0 | 1 |
| 54.9900 | 0 | 1 | 0 | 1 |
| 59.9900 | 0 | 4 | 0 | 1 |
| 60.7450 | 0 | 1 | 0 | 1 |
| 61.9200 | 0 | 2 | 0 | 1 |
| 62.0900 | 0 | 2 | 0 | 1 |
| 63.5000 | 0 | 3 | 0 | 1 |
| 69.9900 | 0 | 3 | 0 | 1 |
| 80.9900 | 3 | 3 | 1 | 3 |
| 85.5650 | 0 | 1 | 0 | 1 |
| 87.7450 | 0 | 1 | 0 | 1 |
| 89.9900 | 0 | 3 | 0 | 1 |
| 91.4900 | 0 | 1 | 0 | 1 |
| 91.5700 | 0 | 1 | 0 | 1 |
| 101.2400 | 0 | 1 | 0 | 1 |
| 102.2900 | 0 | 1 | 0 | 1 |
| 106.5000 | 0 | 2 | 0 | 1 |
| 112.5650 | 0 | 1 | 0 | 1 |
| 120.0000 | 0 | 1 | 0 | 1 |
| 120.2700 | 0 | 2 | 0 | 1 |
| 121.4600 | 0 | 1 | 0 | 1 |
| 121.4900 | 0 | 1 | 0 | 1 |
| 124.7300 | 0 | 1 | 0 | 1 |
| 125.0000 | 0 | 1 | 0 | 1 |
| 133.3400 | 0 | 3 | 0 | 1 |
| 147.1400 | 0 | 3 | 0 | 1 |
| 148.2200 | 0 | 1 | 0 | 1 |
| 159.0000 | 0 | 1 | 0 | 1 |
| 175.4900 | 0 | 2 | 0 | 1 |
| 196.9200 | 0 | 3 | 0 | 1 |
| 209.0250 | 0 | 1 | 0 | 1 |
| 218.0100 | 0 | 1 | 0 | 1 |
| 229.4900 | 0 | 1 | 0 | 1 |
| 236.0250 | 0 | 1 | 0 | 1 |
| 245.0100 | 0 | 1 | 0 | 1 |
| 248.3850 | 0 | 1 | 0 | 1 |
| 249.7900 | 0 | 5 | 0 | 1 |
| 256.4900 | 0 | 1 | 0 | 1 |
| 264.0500 | 0 | 5 | 0 | 1 |
| 275.3850 | 0 | 1 | 0 | 1 |
| 327.2150 | 1 | 1 | 1 | 1 |
| 330.0600 | 0 | 1 | 0 | 1 |
| 333.4200 | 0 | 10 | 0 | 1 |
| 337.2200 | 0 | 12 | 0 | 1 |
| 348.7600 | 0 | 4 | 0 | 1 |
| 357.0600 | 0 | 1 | 0 | 1 |
| 364.0900 | 0 | 4 | 0 | 1 |
| 404.9900 | 0 | 1 | 0 | 1 |
| 539.9900 | 0 | 9 | 0 | 1 |
| 564.9900 | 0 | 5 | 0 | 1 |
| 594.8300 | 0 | 10 | 0 | 1 |
| 742.3500 | 0 | 10 | 0 | 1 |
| 769.4900 | 0 | 4 | 0 | 1 |
| 782.9900 | 0 | 12 | 0 | 1 |
| 1003.9100 | 0 | 8 | 0 | 1 |
| 1079.9900 | 0 | 4 | 0 | 1 |
| 1120.4900 | 0 | 5 | 0 | 1 |
| 1214.8500 | 0 | 4 | 0 | 1 |
| 1349.6000 | 0 | 5 | 0 | 1 |
| 1364.5000 | 0 | 5 | 0 | 1 |
| 1431.5000 | 0 | 11 | 0 | 1 |
| 1457.9900 | 0 | 5 | 0 | 1 |
| 1700.9900 | 0 | 4 | 0 | 1 |
| 2294.9900 | 0 | 3 | 0 | 1 |
| 2319.9900 | 0 | 3 | 0 | 1 |
| 2443.3500 | 8 | 8 | 1 | 8 |
| 3374.9900 | 0 | 4 | 0 | 1 |
| 3399.9900 | 0 | 4 | 0 | 1 |
| 3578.2700 | 0 | 5 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[Product]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [ProductNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MakeFlag] [dbo].[Flag] NOT NULL, [FinishedGoodsFlag] [dbo].[Flag] NOT NULL, [Color] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SafetyStockLevel] [smallint] NOT NULL, [ReorderPoint] [smallint] NOT NULL, [StandardCost] [money] NOT NULL, [ListPrice] [money] NOT NULL, [Size] [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SizeUnitMeasureCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WeightUnitMeasureCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Weight] [decimal](8, 2) NULL, [DaysToManufacture] [int] NOT NULL, [ProductLine] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Class] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Style] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ProductSubcategoryID] [int] NULL, [ProductModelID] [int] NULL, [SellStartDate] [datetime] NOT NULL, [SellEndDate] [datetime] NULL, [DiscontinuedDate] [datetime] NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Product records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ProductID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the product.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique product identification number.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ProductNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Product is purchased, 1 = Product is manufactured in-house.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'MakeFlag' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Product is not a salable item. 1 = Product is salable.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'FinishedGoodsFlag' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product color.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Color' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Minimum inventory quantity. ' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'SafetyStockLevel' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Inventory level that triggers a purchase order or work order. ' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ReorderPoint' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Standard cost of the product.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'StandardCost' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Selling price.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ListPrice' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product size.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Size' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unit of measure for Size column.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'SizeUnitMeasureCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unit of measure for Weight column.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'WeightUnitMeasureCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product weight.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Weight' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of days required to manufacture the product.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'DaysToManufacture' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R = Road, M = Mountain, T = Touring, S = Standard' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ProductLine' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'H = High, M = Medium, L = Low' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Class' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W = Womens, M = Mens, U = Universal' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'Style' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. ' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ProductSubcategoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product is a member of this product model. Foreign key to ProductModel.ProductModelID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ProductModelID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the product was available for sale.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'SellStartDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the product was no longer available for sale.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'SellEndDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the product was discontinued.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'DiscontinuedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Products sold or used in the manfacturing of sold products.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Product' |