Northwind Database (Document! X Sample)
IX_PurchaseOrderHeader_VendorID Index
AdventureWorks Database > Purchasing Schema > Purchasing.PurchaseOrderHeader Table : IX_PurchaseOrderHeader_VendorID Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used72.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.Ascending
Index Statistics
Average key length8.00
Density0.02
Rows in the Table4012
Rows Sampled4012
Distribution Steps59
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Purchasing.PurchaseOrderHeader Table
Purchasing Schema
AdventureWorks Database