Northwind Database (Document! X Sample)
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Index
AdventureWorks Database > Production Schema > Production.TransactionHistoryArchive Table : IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used1,696.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 Purchase order, sales order, or work order identification number.Ascending
 Line number associated with the purchase order, sales order, or work order.Ascending
Index Statistics
Average key length12.00
Density0.60
Rows in the Table89253
Rows Sampled89253
Distribution Steps116
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Production.TransactionHistoryArchive Table
Production Schema
AdventureWorks Database