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: | 1256 |
Fill Factor: | 0 |
Don't Recompute Statistics: | |
Description: | Nonclustered index. |
Name | Descending | Included | |
ProductID |
Updated: | Apr 26 2006 11:50AM |
Average key length: | 8 |
Density: | 1.581469E-02 |
Rows in the table: | 113443 |
Rows sampled for statistics data: | 113443 |
Distribution steps: | 200 |
CREATE INDEX [IX_TransactionHistory_ProductID] ON [Production].[TransactionHistory]([ProductID]) ON [PRIMARY]
GO
See Also
List of indexes