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:	48
Fill Factor:	0
Don't Recompute Statistics:
Description:	Primary key (clustered) constraint

Index Columns

	Name	Descending	Included
	EmployeeID
	DepartmentID
	ShiftID
	StartDate

Total: 4 column(s)

Statistics

Updated:	Apr 26 2006 11:49AM
Average key length:	15
Density:	1
Rows in the table:	296
Rows sampled for statistics data:	296
Distribution steps:	150

SQL

CREATE  UNIQUE  CLUSTERED  INDEX [PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID] ON [HumanResources].[EmployeeDepartmentHistory]([EmployeeID], [StartDate], [DepartmentID], [ShiftID]) ON [PRIMARY]
GO

See Also

List of indexes