Properties

Clustered Index:
Primary Key Index:
Unique Index:
Ignore Duplicates:
Pad Index:
Allow Row Locks:
Allow Page Locks:
Is computed column in index:
Located On:	PRIMARY
Size KB:	1704
Fill Factor:	0
Don't Recompute Statistics:
Description:	Nonclustered index.

Index Columns

	Name	Descending	Included
	ReferenceOrderID
	ReferenceOrderLineID

Total: 2 column(s)

Statistics

Updated:	Apr 26 2006 11:50AM
Average key length:	12
Density:	0.3337781
Rows in the table:	113443
Rows sampled for statistics data:	113443
Distribution steps:	99

SQL

CREATE  INDEX [IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID] ON [Production].[TransactionHistory]([ReferenceOrderID], [ReferenceOrderLineID]) ON [PRIMARY]
GO

See Also

List of indexes