Rem drv: <migrate type="schema_upgrade" version="10.2.0.4" pos="audit_schema_upgrade.sql+"/>
Rem
Rem $Header: audit_indexes.sql 10-aug-2007.11:37:16 pshishir Exp $
Rem
Rem audit_indexes.sql
Rem
Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      audit_indexes.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    pshishir    08/10/07 - Created
Rem
Rem Indexes for MGMT_AUDIT_LOGS table
Rem

-- MGMT_AUDIT_LOGS_IDX01
-- Description: This index is created on "event_timestamp", and op_code, 
-- column for MGMT_AUDIT_LOGS table 

CREATE INDEX MGMT_AUDIT_LOGS_IDX01 ON
   MGMT_AUDIT_LOGS(op_code, time_stamp);