Northwind Database (Document! X Sample)
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate Index
AdventureWorks Database > HumanResources Schema > HumanResources.EmployeePayHistory Table : PK_EmployeePayHistory_BusinessEntityID_RateChangeDate Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used16.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyEmployee identification number. Foreign key to Employee.BusinessEntityID.Ascending
Primary KeyDate the change in pay is effectiveAscending
Index Statistics
Average key length12.00
Density0.97
Rows in the Table316
Rows Sampled316
Distribution Steps153
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

HumanResources.EmployeePayHistory Table
HumanResources Schema
AdventureWorks Database