AdventureWorks
AK_Employee_NationalIDNumber Index
Description
Unique nonclustered index.
Properties
File GroupPRIMARY
Space Used32.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 NationalIDNumberUnique national identification number such as a social security number.Ascending
Index Statistics
Average key length21.66
Density1.00
Rows in the Table290
Rows Sampled290
Distribution Steps177
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

HumanResources.Employee Table
HumanResources Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.