Rem
Rem $Header: assoc_indexes.sql 17-may-2005.00:14:44 rkpandey Exp $
Rem
Rem assoc_indexes.sql
Rem
Rem Copyright (c) 2004, 2005, 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    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    pmodi       05/02/05 - driver tag removed from top 
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 INDEX MGMT_FLAT_TARGET_ASSOC_IDX02 ON MGMT_FLAT_TARGET_ASSOC(SOURCE_TARGET_GUID,ASSOC_TARGET_GUID);

CREATE INDEX MGMT_FLAT_TARGET_ASSOC_IDX03 ON MGMT_FLAT_TARGET_ASSOC(ASSOC_TARGET_GUID,SOURCE_TARGET_GUID);