AdventureWorks Database > Purchasing Schema > Purchasing.PurchaseOrderDetail Table : IX_PurchaseOrderDetail_ProductID Index |
File Group | PRIMARY |
Space Used | 152.00 KB |
Fill Factor | 0 |
Do not Recompute Statistics | |
Full Text Key | |
Clustered Index | |
Primary Key Index | |
Unique Index | |
Pad Index |
Column | Description | Sort Order | |
---|---|---|---|
ProductID | Product identification number. Foreign key to Product.ProductID. | Ascending |
Average key length | 12.00 |
Density | 0.05 |
Rows in the Table | 8845 |
Rows Sampled | 8845 |
Distribution Steps | 138 |
Updated | Jan 8 2010 8:41AM |