| name | value |
|---|---|
| name | HR.LOCATIONS.LOC_STATE_PROVINCE_IX |
| size | 8 kb |
| type | NORMAL |
| parent | LOCATIONS |
| uniqueness | NONUNIQUE |
| compression | DISABLED |
| blevel | 0 |
| leaf blocks | 1 |
| distinct keys | 17 |
| avg leaf blocks per key | 1 |
| avg data blocks per key | 1 |
| clustering factor | 1 |
| status | VALID |
| num rows | 17 |
| sample size | 17 |
| 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 |
| name | position | column length (bytes) | column length (chars) | order |
|---|---|---|---|---|
| STATE_PROVINCE | 1 | 25 | 25 | ASC |
| name | object type | level |
|---|