Northwind Database (Document! X Sample)
AdventureWorks Database > Production Schema > Production.TransactionHistory Table : IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID Index
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used2,200.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.33
Rows in the Table113443
Rows Sampled113443
Distribution Steps114
UpdatedJul 17 2014 4:11PM
See Also