! Copyright © Oracle Corporation 1995.  All Rights Reserved.
!
! Now that the load programs have finished, define other sorted (b-tree)
! indexes for MF_PERSONNEL.  The definition of these indexes is performed
! after the load programs complete for two reasons:
! 
!   1. The design did not call for placement of the records these
!      indexes serve according to the sorted order of the indexes.
!
!   2. To speed up the performance of the load operation.
!
!
START_TRANSACTION READ_WRITE
!
! 
PRINT "Defining sorted indexes for MF_PERSONNEL"
!
! Index for EMPLOYEES:
!
DEFINE INDEX EMP_EMPLOYEE_ID FOR EMPLOYEES
    DUPLICATES ARE NOT ALLOWED
    TYPE IS SORTED.
        EMPLOYEE_ID.
END EMP_EMPLOYEE_ID INDEX.
! 
! Indexes for JOB_HISTORY:
! 
DEFINE INDEX JH_EMPLOYEE_ID FOR JOB_HISTORY
    DUPLICATES ARE ALLOWED
    TYPE IS SORTED.
        EMPLOYEE_ID.
END JH_EMPLOYEE_ID INDEX.
! 
! Indexes for SALARY_HISTORY:
! 
DEFINE INDEX SH_EMPLOYEE_ID FOR SALARY_HISTORY
    DUPLICATES ARE ALLOWED
    TYPE IS SORTED.
        EMPLOYEE_ID.
END SH_EMPLOYEE_ID INDEX.
! 
! Index for DEGREES:
! 
DEFINE INDEX DEG_COLLEGE_CODE FOR DEGREES
    DUPLICATES ARE ALLOWED
    TYPE IS SORTED.
        COLLEGE_CODE.
END DEG_COLLEGE_CODE INDEX.
!
DEFINE INDEX DEG_EMP_ID FOR DEGREES
    DUPLICATES ARE ALLOWED
    TYPE IS SORTED.
        EMPLOYEE_ID.
END DEG_EMP_ID INDEX.
! 
! Index for COLLEGES:
! 
DEFINE INDEX COLL_COLLEGE_CODE FOR COLLEGES
    DUPLICATES ARE NOT ALLOWED
    TYPE IS SORTED.
        COLLEGE_CODE.
END COLL_COLLEGE_CODE INDEX.
! 
! --- End defining sorted indexes
!
! 
COMMIT
!