Rem Rem $Header: hr_idx.sql 29-aug-2002.11:44:09 hyeh Exp $ Rem Rem hr_idx.sql Rem Rem Copyright (c) 2001, 2002, Oracle Corporation. All rights reserved. Rem Rem NAME Rem hr_idx.sql - Create indexes for HR schema Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem CREATED by Nancy Greenberg - 06/01/00 Rem MODIFIED (MM/DD/YY) Rem hyeh 08/29/02 - hyeh_mv_comschema_to_rdbms Rem ahunold 02/20/01 - New header Rem vpatabal 03/02/01 - Removed DROP INDEX statements SET FEEDBACK 1 SET NUMWIDTH 10 SET LINESIZE 80 SET TRIMSPOOL ON SET TAB OFF SET PAGESIZE 100 SET ECHO OFF CREATE INDEX emp_department_ix ON employees (department_id); CREATE INDEX emp_job_ix ON employees (job_id); CREATE INDEX emp_manager_ix ON employees (manager_id); CREATE INDEX emp_name_ix ON employees (last_name, first_name); CREATE INDEX dept_location_ix ON departments (location_id); CREATE INDEX jhist_job_ix ON job_history (job_id); CREATE INDEX jhist_employee_ix ON job_history (employee_id); CREATE INDEX jhist_department_ix ON job_history (department_id); CREATE INDEX loc_city_ix ON locations (city); CREATE INDEX loc_state_province_ix ON locations (state_province); CREATE INDEX loc_country_ix ON locations (country_id); COMMIT;