Index properties
| name | value |
|---|
| name | HR.EMPLOYEES.EMP_NAME_IX
|
| size | 8 kb
|
| type | NORMAL
|
| parent | EMPLOYEES
|
| uniqueness | NONUNIQUE
|
| compression | DISABLED
|
| blevel | 0
|
| leaf blocks | 1
|
| distinct keys | 107
|
| avg leaf blocks per key | 1
|
| avg data blocks per key | 1
|
| clustering factor | 15
|
| 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 |
|---|
| LAST_NAME
| 1
| 25
| 25
| ASC
|
| FIRST_NAME
| 2
| 20
| 20
| ASC
|
Dependency graph
Objects that HR.EMPLOYEES.EMP_NAME_IX depends on
Documentation generated by SqlSpec