Rem drv: <create type="indexes" pos="service_level/service_level_indexes.sql+"/>
Rem
Rem $Header: provision_indexes.sql 29-jun-2005.01:48:52 gsbhatia Exp $
Rem
Rem provision_indexes.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      provision_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    gsbhatia    06/26/05 - New repmgr header impl 
Rem    rmadampa    05/08/05 - add cluster indexes 
Rem    rmadampa    04/27/05 - data model enhancements 1 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    pshroff     11/03/04 - pshroff_search-ecm
Rem    pshroff     11/03/04 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

SET SERVEROUTPUT ON
SHOW ERRORS

CREATE INDEX mgmt_prov_hardware_index1 ON
  mgmt_prov_hardware(name, hostname, mac_address1, serial_number);

CREATE INDEX mgmt_prov_status_index1 ON
  mgmt_prov_tgt_status(component_urn, network_urn, status);

CREATE INDEX mgmt_prov_asn_index1 ON
  mgmt_prov_assignment(component_urn, network_urn, stage_urn);

SET SERVEROUTPUT ON