Indexes

The below columns will be indexed. These indexes are in addition to those implied by the unique/primary key constraints defined above for each table. All of the given indexes are non-unique.

Table (Columns)	Oracle	SQL Server
`sp057_regions (owning_region_no)`
`sp070_activity_standards (activity_type)`
`sp070_activity_standards (activity_type)`
`sp100_activities (employee_no)`
`sp100_activities (job_no)`
`sp100_activities (employee_work_loc)`
`sp100_activities (job_no, job_location_no)`
`sp147_job_acc_hours_overrides (job_no)`
`sp148_job_aho_periods (job_no)`
`sp149_job_serv_jours_overrides (job_no)`
`sp152_job_sho_periods (job_no)`
`sp210_employees (name)`
`sp309_spare_substitutes (job_no, job_equip_no, job_location_no)`
`sp560_travel_status_history (timestamp, employee_no)`
`sp507_audit_sp100 (sequence)`
`sp508_audit_sp108 (sequence)`
`sp509_audit_sp111 (sequence)`