Index properties
| name | value |
|---|
| name | HR.EMPLOYEES.EMP_JOB_IX
|
| size | 8 kb
|
| type | NORMAL
|
| parent | EMPLOYEES
|
| uniqueness | NONUNIQUE
|
| compression | DISABLED
|
| blevel | 0
|
| leaf blocks | 1
|
| distinct keys | 19
|
| avg leaf blocks per key | 1
|
| avg data blocks per key | 1
|
| clustering factor | 8
|
| status | VALID
|
| num rows | 107
|
| sample size | 107
|
| 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 |
|---|
| JOB_ID
| 1
| 10
| 10
| ASC
|
Dependency graph
Objects that HR.EMPLOYEES.EMP_JOB_IX depends on
Documentation generated by SqlSpec