-- Copyright © Oracle Corporation 1995.  All Rights Reserved.
--
-- *** Define indexes for PERSONNEL ***
--
print 'Creating indexes for the sample database';
-- 
DECLARE TRANSACTION READ WRITE;
-- 
-- Index for EMPLOYEES:
-- 
CREATE UNIQUE INDEX EMP_EMPLOYEE_ID ON EMPLOYEES (EMPLOYEE_ID);
CREATE INDEX EMP_LAST_NAME ON EMPLOYEES (LAST_NAME);

-- 
-- Indexes for JOB_HISTORY:
-- 
CREATE INDEX JH_EMPLOYEE_ID ON JOB_HISTORY (EMPLOYEE_ID);

-- 
-- Indexes for SALARY_HISTORY:
-- 
CREATE INDEX SH_EMPLOYEE_ID ON SALARY_HISTORY (EMPLOYEE_ID);

-- 
-- Index for DEGREES:
-- 
CREATE INDEX DEG_COLLEGE_CODE ON DEGREES (COLLEGE_CODE);

CREATE INDEX DEG_EMP_ID ON DEGREES (EMPLOYEE_ID);

-- 
-- Index for COLLEGES:
-- 
CREATE UNIQUE INDEX COLL_COLLEGE_CODE ON COLLEGES (COLLEGE_CODE);
-- 
-- 
COMMIT;
--