| name | value |
|---|---|
| name | HR.JOB_HISTORY.JHIST_EMP_ID_ST_DATE_PK |
| size | 8 kb |
| type | NORMAL |
| parent | JOB_HISTORY |
| uniqueness | UNIQUE |
| compression | DISABLED |
| blevel | 0 |
| leaf blocks | 1 |
| distinct keys | 10 |
| avg leaf blocks per key | 1 |
| avg data blocks per key | 1 |
| clustering factor | 1 |
| status | VALID |
| num rows | 10 |
| sample size | 10 |
| 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 |
|---|---|---|---|---|
| EMPLOYEE_ID | 1 | 22 | 0 | ASC |
| START_DATE | 2 | 7 | 0 | ASC |
| name | object type | level |
|---|