AdventureWorks Database > Person Schema > Person.Address Table : IX_Address_StateProvinceID Index |
File Group | PRIMARY |
Space Used | 232.00 KB |
Fill Factor | 0 |
Do not Recompute Statistics | ![]() |
Full Text Key | ![]() |
Clustered Index | ![]() |
Primary Key Index | ![]() |
Unique Index | ![]() |
Pad Index | ![]() |
Column | Description | Sort Order | |
---|---|---|---|
StateProvinceID | Unique identification number for the state or province. Foreign key to StateProvince table. | Ascending |
Average key length | 8.00 |
Density | 0.06 |
Rows in the Table | 19614 |
Rows Sampled | 19614 |
Distribution Steps | 71 |
Updated | Jan 8 2010 8:41AM |