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 EMAIL 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