| 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 |