Index Summary
Index Name Index Type Uniqueness Table Owner Table Name Columns Size Tablespace
COUNTRY_C_ID_PK IOT-TOP UNIQUE HR COUNTRIES 1 64K USERS
DEPT_ID_PK NORMAL UNIQUE HR DEPARTMENTS 1 64K USERS
DEPT_LOCATION_IX NORMAL NON-UNIQUE HR DEPARTMENTS 1 64K USERS
EMP_DEPARTMENT_IX NORMAL NON-UNIQUE HR EMPLOYEES 1 64K USERS
EMP_EMAIL_UK NORMAL UNIQUE HR EMPLOYEES 1 64K USERS
EMP_EMP_ID_PK NORMAL UNIQUE HR EMPLOYEES 1 64K USERS
EMP_JOB_IX NORMAL NON-UNIQUE HR EMPLOYEES 1 64K USERS
EMP_MANAGER_IX NORMAL NON-UNIQUE HR EMPLOYEES 1 64K USERS
EMP_NAME_IX NORMAL NON-UNIQUE HR EMPLOYEES 2 64K USERS
JHIST_DEPARTMENT_IX NORMAL NON-UNIQUE HR JOB_HISTORY 1 64K USERS
JHIST_EMPLOYEE_IX NORMAL NON-UNIQUE HR JOB_HISTORY 1 64K USERS
JHIST_EMP_ID_ST_DATE_PK NORMAL UNIQUE HR JOB_HISTORY 2 64K USERS
JHIST_JOB_IX NORMAL NON-UNIQUE HR JOB_HISTORY 1 64K USERS
JOB_ID_PK NORMAL UNIQUE HR JOBS 1 64K USERS
LOC_CITY_IX NORMAL NON-UNIQUE HR LOCATIONS 1 64K USERS
LOC_COUNTRY_IX NORMAL NON-UNIQUE HR LOCATIONS 1 64K USERS
LOC_ID_PK NORMAL UNIQUE HR LOCATIONS 1 64K USERS
LOC_STATE_PROVINCE_IX NORMAL NON-UNIQUE HR LOCATIONS 1 64K USERS
REG_ID_PK NORMAL UNIQUE HR REGIONS 1 64K USERS
TESTTABLEX_PK NORMAL UNIQUE HR TESTTABLEX 3 64K USERS