Northwind Database (Document! X Sample)
IX_PersonPhone_PhoneNumber Index
AdventureWorks Database > Person Schema > Person.PersonPhone Table : IX_PersonPhone_PhoneNumber Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used976.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyTelephone number identification number.Ascending
Index Statistics
Average key length38.44
Density0.73
Rows in the Table19972
Rows Sampled19972
Distribution Steps172
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Person.PersonPhone Table
Person Schema
AdventureWorks Database