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: | Nonclustered index. |
Name | Descending | Included | |
ShiftID |
Updated: | Apr 26 2006 11:50AM |
Average key length: | 15 |
Density: | 0 |
Rows in the table: | 296 |
Rows sampled for statistics data: | 296 |
Distribution steps: | 3 |
CREATE INDEX [IX_EmployeeDepartmentHistory_ShiftID] ON [HumanResources].[EmployeeDepartmentHistory]([ShiftID]) ON [PRIMARY]
GO
See Also
List of indexes