INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS | COLUMN_EXPRESSION | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | LOW_PRIVS | EMP_JOB_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | JOB_ID | null |
2 | LOW_PRIVS | EMP_NAME_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | LAST_NAME, FIRST_NAME | null |
3 | LOW_PRIVS | EMP_EMAIL_UK | UNIQUE | VALID | NORMAL | N | NO | null | NO | null | |
4 | LOW_PRIVS | EMP_EMP_ID_PK | UNIQUE | VALID | NORMAL | N | NO | null | NO | EMPLOYEE_ID | null |
5 | LOW_PRIVS | EMP_MANAGER_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | MANAGER_ID | null |
6 | LOW_PRIVS | EMP_DEPARTMENT_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | DEPARTMENT_ID | null |