Index properties
| name | value |
|---|
| name | HR.LOCATIONS.LOC_CITY_IX
|
| size | 8 kb
|
| type | NORMAL
|
| parent | LOCATIONS
|
| uniqueness | NONUNIQUE
|
| compression | DISABLED
|
| blevel | 0
|
| leaf blocks | 1
|
| distinct keys | 23
|
| avg leaf blocks per key | 1
|
| avg data blocks per key | 1
|
| clustering factor | 1
|
| status | VALID
|
| num rows | 23
|
| sample size | 23
|
| last analyzed | 9/26/2010 7:27:41 PM
|
| degree | 1
|
| instances | 1
|
| partitioned | NO
|
| temporary | N
|
| generated | N
|
| secondary | N
|
| user stats | NO
|
| global stats | YES
|
| join index | NO
|
| iot redundant pkey elim | NO
|
| dropped | NO
|
Index columns
| name | position | column length (bytes) | column length (chars) | order |
|---|
| CITY
| 1
| 30
| 30
| ASC
|
Dependency graph
Objects that HR.LOCATIONS.LOC_CITY_IX depends on
Documentation generated by SqlSpec