Rem drv: <create type="indexes" pos="rca/rca_indexes.sql+"/>
Rem
Rem $Header: assoc_indexes.sql 07-jul-2006.22:03:42 pmodi Exp $
Rem
Rem assoc_indexes.sql
Rem
Rem Copyright (c) 2004, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      assoc_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    pmodi       07/07/06 - Backport pmodi_bug-5097850 from main 
Rem    pmodi       05/08/06 - Bug:5108507 - Redefine index on flat table
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    rkpandey    05/17/05 - Bug-4353778: Creating new index and removing 
Rem                           redundant ones 
Rem    pmodi       05/18/05 - Bug:4365129: removing redundant index 
Rem    ramalhot    04/22/05 - index on mgmt_target_assoc_count removed 
Rem    pmodi       04/16/05 - added index for mgmt_target_assoc_count 
Rem    pmodi       04/13/05 - New index on mgmt_flat_target_assoc 
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    ramalhot    12/02/04 - bitmap index removed 
Rem    ramalhot    09/10/04 - indexes added 
Rem    ramalhot    07/07/04 - ramalhot_assoc_object_creation
Rem    ramalhot    07/06/04 - Created
Rem


CREATE INDEX MGMT_TARGET_ASSOCS_IDX03 ON MGMT_TARGET_ASSOCS (ASSOC_GUID);

CREATE UNIQUE INDEX UK_MGMT_TARGET_ASSOCS ON MGMT_TARGET_ASSOCS (ASSOC_TARGET_GUID, ASSOC_GUID, SOURCE_TARGET_GUID, SCOPE_TARGET_GUID);

CREATE UNIQUE INDEX MGMT_FLAT_TARGET_ASSOC_IDX02 ON MGMT_FLAT_TARGET_ASSOC(SOURCE_TARGET_GUID,ASSOC_TARGET_GUID)
COMPRESS 1;

CREATE UNIQUE INDEX MGMT_FLAT_TARGET_ASSOC_IDX03 ON MGMT_FLAT_TARGET_ASSOC(ASSOC_TARGET_GUID,SOURCE_TARGET_GUID)
COMPRESS 1;

CREATE INDEX MGMT_FLAT_TARGET_ASSOC_IDX01 ON MGMT_FLAT_TARGET_ASSOC (SOURCE_TARGET_GUID, IS_MEMBERSHIP)
COMPRESS 1 ;

CREATE INDEX MGMT_FLAT_TARGET_ASSOC_IDX04 ON MGMT_FLAT_TARGET_ASSOC (ASSOC_TARGET_GUID, IS_MEMBERSHIP)
COMPRESS 1 ;