| name | value |
|---|---|
| name | HR.EMPLOYEES_MV.EMP_EMP_ID_PK1 |
| size | 8 kb |
| type | NORMAL |
| parent | EMPLOYEES_MV |
| uniqueness | UNIQUE |
| compression | DISABLED |
| blevel | 0 |
| leaf blocks | 1 |
| distinct keys | 107 |
| avg leaf blocks per key | 1 |
| avg data blocks per key | 1 |
| clustering factor | 2 |
| status | VALID |
| num rows | 107 |
| sample size | 107 |
| last analyzed | 11/21/2010 7:40:10 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 |
| name | object type | level |
|---|