Northwind Database (Document! X Sample)
PK_ProductInventory_ProductID_LocationID Index
AdventureWorks Database > Production Schema > Production.ProductInventory Table : PK_ProductInventory_ProductID_LocationID Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used16.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyProduct identification number. Foreign key to Product.ProductID.Ascending
Primary KeyInventory location identification number. Foreign key to Location.LocationID. Ascending
Index Statistics
Average key length6.00
Density0.43
Rows in the Table1069
Rows Sampled1069
Distribution Steps198
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Production.ProductInventory Table
Production Schema
AdventureWorks Database