| name | value |
|---|---|
| name | HR.DEPARTMENTS.DEPT_LOCATION_IX |
| size | 8 kb |
| type | NORMAL |
| parent | DEPARTMENTS |
| uniqueness | NONUNIQUE |
| compression | DISABLED |
| blevel | 0 |
| leaf blocks | 1 |
| distinct keys | 7 |
| avg leaf blocks per key | 1 |
| avg data blocks per key | 1 |
| clustering factor | 1 |
| status | VALID |
| num rows | 27 |
| sample size | 27 |
| 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 |
|---|---|---|---|---|
| LOCATION_ID | 1 | 22 | 0 | ASC |
| name | object type | level |
|---|