-- Copyright © Oracle Corporation 1995.  All Rights Reserved.
--
-- Now that the load programs have finished, define other sorted indexes
-- for MF_PERSONNEL.  The definition of these indexes is performed
-- after the load programs complete for two reasons:
--
--   1. The database design does not require that records be placed
--      according to the order specified in these indexes. 
--
--   2. The load operation runs faster if these indexes are defined later.
--
--
print 'Creating remaining sorted indexes for MF_PERSONNEL';
--
--
-- *** Define indexes for PERSONNEL ***
--
-- 
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;
--