AdventureWorks
AK_Customer_AccountNumber Index
Description
Unique nonclustered index.
Properties
File GroupPRIMARY
Space Used416.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 AccountNumberUnique number identifying the customer assigned by the accounting system.Ascending
Index Statistics
Average key length14.00
Density1.00
Rows in the Table19185
Rows Sampled19185
Distribution Steps155
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

Sales.Customer Table
Sales Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.