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: | 16 |
Fill Factor: | 0 |
Don't Recompute Statistics: | |
Description: | Primary key (clustered) constraint |
Name | Descending | Included | |
ProductID | |||
StartDate |
Updated: | Apr 26 2006 11:49AM |
Average key length: | 12 |
Density: | 0.75 |
Rows in the table: | 395 |
Rows sampled for statistics data: | 395 |
Distribution steps: | 152 |
CREATE UNIQUE CLUSTERED INDEX [PK_ProductCostHistory_ProductID_StartDate] ON [Production].[ProductCostHistory]([ProductID], [StartDate]) ON [PRIMARY]
GO
See Also
List of indexes