create index IND_CK_APPLOG_CTX_REPOS_ELEM on i$CK_APPLICATION_LOGIC(AL_EVT_CONTEXT_REPOS_ELEMENT)
/
create index IND_CK_APPLOG_REPOS_ELEM on i$CK_APPLICATION_LOGIC(AL_REPOS_ELEMENT)
/
create index CK_APPLICATION_LOGIC_PK_idx on i$CK_APPLICATION_LOGIC(AL_ID)
/
create index RM_TEXT_LINES_ix on i$RM_TEXT_LINES(parent_ivid)
/
create index TEXT_PRIME on i$RM_TEXT_LINES(TXT_REF,TXT_SEQ,TXT_TYPE)
/
create index SDD_NLS_MESSAGES_PK_idx on l$SDD_NLS_MESSAGES(MSGNO)
/
create index SDD_NLS_MESSAGES_NAME_idx on l$SDD_NLS_MESSAGES(MNEMONIC)
/
create index SDD_PROMPTS_PK_idx on l$SDD_NLS_PROMPTS(PMPTNO)
/
create index SDD_NLS_PL_ENTRIES_PK_idx on l$SDD_NLS_PROPLIST_ENTRIES(PLID,PROPERTY,SEQ)
/
create index SDD_RESOURCES_PK_idx on l$SDD_NLS_RESOURCES(RESID)
/
create index SDD_RESOURCES_MNEMONIC_idx on l$SDD_NLS_RESOURCES(MNEMONIC)
/
create index SDD_PROPLISTS_PK_idx on i$SDD_PROPERTY_LISTS(PLID)
/
create index SDD_PL_ENTRIES_PK_idx on i$SDD_PROPLIST_ENTRIES(PLID,PROPERTY,SEQ)
/
create index IND_WIDGET_TYPE on i$SDD_WIDGETS(WIDGET_TYPE)
/
create index SDD_WIDGETS_PK_idx on i$SDD_WIDGETS(WID)
/
create index SDD_WIDGET_UNIQUE_NAME_idx on i$SDD_WIDGETS(WIDGET_NAME)
/
create index IND_FK_A1_TO_E1 on i$SDD_A1(OBJECTIVE_REF, parent_ivid)
/
create index IND_FK_A1_TO_E2 on i$SDD_A1(CSF_REF)
/
create index PK_SDD_A1_idx on i$SDD_A1(IRID)
/
create index IND_FK_A10_TO_BUN on i$SDD_A10(BUSINESS_UNIT_REF, parent_ivid)
/
create index IND_FK_A10_TO_E5 on i$SDD_A10(PROBLEM_REF)
/
create index PK_SDD_A10_idx on i$SDD_A10(IRID)
/
create index IND_FK_A11_TO_E3 on i$SDD_A11(KPI_REF, parent_ivid)
/
create index IND_FK_A11_TO_FUN on i$SDD_A11(FUNCTION_REF)
/
create index PK_SDD_A11_idx on i$SDD_A11(IRID)
/
create index IND_FK_A2_TO_E1 on i$SDD_A2(OBJECTIVE_REF, parent_ivid)
/
create index IND_FK_A2_TO_MOD on i$SDD_A2(MODULE_REF)
/
create index PK_SDD_A2_idx on i$SDD_A2(IRID)
/
create index IND_FK_A20_TO_E20 on i$SDD_A20(PART_OF_NODE_REF, parent_ivid)
/
create index IND_FK_A20_TO_E202 on i$SDD_A20(USE_OF_NODE_REF)
/
create index PK_SDD_A20_idx on i$SDD_A20(IRID)
/
create index IND_FK_A21_TO_E20 on i$SDD_A21(NODE_REF)
/
create index IND_FK_A21_TO_E6 on i$SDD_A21(LOCATION_REF, parent_ivid)
/
create index PK_SDD_A21_idx on i$SDD_A21(IRID)
/
create index IND_FK_A23_TO_E20 on i$SDD_A23(NODE_REF, parent_ivid)
/
create index IND_FK_A23_TO_MOD on i$SDD_A23(MODULE_REF)
/
create index PK_SDD_A23_idx on i$SDD_A23(IRID)
/
create index IND_FK_A24_TO_BUN on i$SDD_A24(BUSINESS_UNIT_REF)
/
create index IND_FK_A24_TO_E20 on i$SDD_A24(NODE_REF, parent_ivid)
/
create index PK_SDD_A24_idx on i$SDD_A24(IRID)
/
create index IND_FK_A3_TO_E1 on i$SDD_A3(OBJECTIVE_REF, parent_ivid)
/
create index IND_FK_A3_TO_E3 on i$SDD_A3(KPI_REF)
/
create index PK_SDD_A3_idx on i$SDD_A3(IRID)
/
create index IND_FK_A4_TO_E1 on i$SDD_A4(OBJECTIVE_REF, parent_ivid)
/
create index IND_FK_A4_TO_FUN on i$SDD_A4(FUNCTION_REF)
/
create index PK_SDD_A4_idx on i$SDD_A4(IRID)
/
create index IND_FK_A5_TO_E4 on i$SDD_A5(ASSUMPTION_REF, parent_ivid)
/
create index IND_FK_A5_TO_MOD on i$SDD_A5(MODULE_REF)
/
create index PK_SDD_A5_idx on i$SDD_A5(IRID)
/
create index IND_FK_A6_TO_E4 on i$SDD_A6(ASSUMPTION_REF, parent_ivid)
/
create index IND_FK_A6_TO_TAB on i$SDD_A6(TABLE_REF)
/
create index PK_SDD_A6_idx on i$SDD_A6(IRID)
/
create index IND_FK_A7_TO_E5 on i$SDD_A7(PROBLEM_REF, parent_ivid)
/
create index IND_FK_A7_TO_MOD on i$SDD_A7(MODULE_REF)
/
create index PK_SDD_A7_idx on i$SDD_A7(IRID)
/
create index IND_FK_A8_TO_BUN on i$SDD_A8(BUSINESS_UNIT_REF, parent_ivid)
/
create index IND_FK_A8_TO_E1 on i$SDD_A8(OBJECTIVE_REF)
/
create index PK_SDD_A8_idx on i$SDD_A8(IRID)
/
create index IND_FK_A9_TO_BUN on i$SDD_A9(BUSINESS_UNIT_REF)
/
create index IND_FK_A9_TO_E6 on i$SDD_A9(LOCATION_REF, parent_ivid)
/
create index PK_SDD_A9_idx on i$SDD_A9(IRID)
/
create index IND_FK_ACI_TO_MCN on i$SDD_ACI(MCN_REF, parent_ivid)
/
create index IND_FK_ACI_TO_MCN2 on i$SDD_ACI(MCN_REF_TO)
/
create index IND_FK_ACI_TO_MODMOD on i$SDD_ACI(MODULE_NETWORK_REF)
/
create index IND_FK_ACI_TO_WIN on i$SDD_ACI(WINDOW_REF, parent_ivid)
/
create index PK_SDD_ACI_idx on i$SDD_ACI(IRID)
/
create index IND_FK_ACR_TO_FILES on i$SDD_ACR(ICON_FILE_REF)
/
create index IND_NAME_ACR on i$SDD_ACR(NAME)
/
create index PK_SDD_ACR_idx on i$SDD_ACR(IRID)
/
create index IND_FK_ACRACR_TO_ACR on i$SDD_ACRACR(SUBTYPE_ACTOR_REF, parent_ivid)
/
create index IND_FK_ACRACR_TO_ACR2 on i$SDD_ACRACR(SUPERTYPE_ACTOR_REF)
/
create index PK_SDD_ACRACR_idx on i$SDD_ACRACR(IRID)
/
create index UK_ACRACR_2_idx on i$SDD_ACRACR(SUPERTYPE_ACTOR_REF,SEQUENCE)
/
create index IND_FK_ACRORG_TO_ACR on i$SDD_ACRORG(ACTOR_REF)
/
create index IND_FK_ACRORG_TO_ORG on i$SDD_ACRORG(ORGANIZATION_UNIT_REF, parent_ivid)
/
create index PK_SDD_ACRORG_idx on i$SDD_ACRORG(IRID)
/
create index IND_FK_ACT_TO_FILES on i$SDD_ACT(ICON_FILE_REF)
/
create index IND_FK_ACT_TO_FILES2 on i$SDD_ACT(EXECUTABLE_FILE_REF)
/
create index IND_FK_ACT_TO_FILES3 on i$SDD_ACT(MAPPING_FILE_REF)
/
create index IND_FK_ACT_TO_GEA on i$SDD_ACT(GENERAL_ACTION_REF)
/
create index IND_FK_ACT_TO_MET on i$SDD_ACT(METHOD_REF)
/
create index IND_FK_ACT_TO_PCK on i$SDD_ACT(PACKAGE_REF)
/
create index IND_FK_ACT_TO_RUL on i$SDD_ACT(PRE_RULE_REF)
/
create index IND_FK_ACT_TO_RUL2 on i$SDD_ACT(POST_RULE_REF)
/
create index IND_FK_ACT_TO_USC on i$SDD_ACT(USE_CASE_REF)
/
create index IND_NAME_ACT on i$SDD_ACT(NAME)
/
create index PK_SDD_ACT_idx on i$SDD_ACT(IRID)
/
create index IND_FK_ACTACT_TO_ACT on i$SDD_ACTACT(PARENT_ACTIVITY_REF, parent_ivid)
/
create index IND_FK_ACTACT_TO_ACT2 on i$SDD_ACTACT(CHILD_ACTIVITY_REF)
/
create index PK_SDD_ACTACT_idx on i$SDD_ACTACT(IRID)
/
create index IND_FK_ACTE1_TO_ACT on i$SDD_ACTE1(ACTIVITY_DEFINITION_REF, parent_ivid)
/
create index IND_FK_ACTE1_TO_E1 on i$SDD_ACTE1(OBJECTIVE_REF, parent_ivid)
/
create index PK_SDD_ACTE1_idx on i$SDD_ACTE1(IRID)
/
create index IND_FK_ACTORG_TO_ACT on i$SDD_ACTORG(ACTIVITY_REF, parent_ivid)
/
create index IND_FK_ACTORG_TO_ACTORG on i$SDD_ACTORG(ACTIVITY_USAGE_REF)
/
create index IND_FK_ACTORG_TO_ACTORG2 on i$SDD_ACTORG(ACTIVITY_USAGE_ERROR_REF)
/
create index IND_FK_ACTORG_TO_ORG on i$SDD_ACTORG(ORGANIZATION_UNIT_REF)
/
create index IND_FK_ACTORG_TO_WIT on i$SDD_ACTORG(WORKFLOW_ITEM_TYPE_REF)
/
create index IND_FK_ACTORG_TO_WMT on i$SDD_ACTORG(WORKFLOW_MESS_TYPE_REF)
/
create index PK_SDD_ACTORG_idx on i$SDD_ACTORG(IRID)
/
create index IND_FK_ACUACR_TO_ACR on i$SDD_ACUACR(ACTOR_REF)
/
create index IND_FK_ACUACR_TO_ACTORG on i$SDD_ACUACR(ACTIVITY_USAGE_REF, parent_ivid)
/
create index PK_SDD_ACUACR_idx on i$SDD_ACUACR(IRID)
/
create index IND_FK_ADR_TO_CAT on i$SDD_ADR(CLASSIFIER_ATTRIBUTE_REF, parent_ivid)
/
create index IND_FK_ADR_TO_LAN on i$SDD_ADR(LANGUAGE_REF)
/
create index IND_FK_ADR_TO_MET on i$SDD_ADR(METHOD_REF)
/
create index PK_SDD_ADR_idx on i$SDD_ADR(IRID)
/
create index IND_FK_AEN_TO_ASS on i$SDD_AEN(ASSOCIATION_REF, parent_ivid)
/
create index IND_FK_AEN_TO_CLA on i$SDD_AEN(CLASSIFIER_REF)
/
create index IND_FK_AEN_TO_EOC on i$SDD_AEN(ENTITY_OBJECT_REF)
/
create index IND_FK_AEN_TO_GEC on i$SDD_AEN(GENERIC_CLASS_REF)
/
create index IND_FK_AEN_TO_INC on i$SDD_AEN(INTERFACE_CLASSIFIER_REF)
/
create index IND_FK_AEN_TO_UNR on i$SDD_AEN(UNIQUENESS_RULE_REF)
/
create index IND_NAME_AEN on i$SDD_AEN(NAME)
/
create index PK_SDD_AEN_idx on i$SDD_AEN(IRID)
/
create index IND_FK_AENEAT_TO_AEN on i$SDD_AENEAT(ASSOCIATION_END_REF, parent_ivid)
/
create index IND_FK_AENEAT_TO_EAT on i$SDD_AENEAT(EO_ATTRIBUTE_FROM_REF)
/
create index IND_FK_AENEAT_TO_EAT2 on i$SDD_AENEAT(EO_ATTRIBUTE_TO_REF)
/
create index PK_SDD_AENEAT_idx on i$SDD_AENEAT(IRID)
/
create index IND_FK_AEU_TO_AEN on i$SDD_AEU(ASSOCIATION_END_REF)
/
create index IND_FK_AEU_TO_AEU on i$SDD_AEU(ASSOC_END_USAGE_REF)
/
create index IND_FK_AEU_TO_EOU on i$SDD_AEU(ENTITY_OBJECT_USAGE_REF, parent_ivid)
/
create index PK_SDD_AEU_idx on i$SDD_AEU(IRID)
/
create index IND_FK_AMCAMC_TO_AMC on i$SDD_AMCAMC(PARENT_APP_MODULE_REF, parent_ivid)
/
create index IND_FK_AMCAMC_TO_AMC2 on i$SDD_AMCAMC(CHILD_APP_MODULE_REF)
/
create index PK_SDD_AMCAMC_idx on i$SDD_AMCAMC(IRID)
/
create index IND_FK_AMCBOB_TO_AMC on i$SDD_AMCBOB(APPLICATION_MODULE_REF, parent_ivid)
/
create index IND_FK_AMCBOB_TO_BOB on i$SDD_AMCBOB(BUSINESS_OBJECT_REF)
/
create index PK_SDD_AMCBOB_idx on i$SDD_AMCBOB(IRID)
/
create index IND_FK_AMCPRJ_TO_AMC on i$SDD_AMCPRJ(APPLICATION_MODULE_REF, parent_ivid)
/
create index IND_FK_AMCPRJ_TO_PRJ on i$SDD_AMCPRJ(PROJECT_REF)
/
create index PK_SDD_AMCPRJ_idx on i$SDD_AMCPRJ(IRID)
/
create index IND_FK_ARG_TO_COL on i$SDD_ARG(COLUMN_REF)
/
create index IND_FK_ARG_TO_DAT on i$SDD_ARG(DATASTRUCTURE_REF)
/
create index IND_FK_ARG_TO_DOM on i$SDD_ARG(DOMAIN_REF)
/
create index IND_FK_ARG_TO_GEM on i$SDD_ARG(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_ARG_TO_ORT on i$SDD_ARG(ORACLE_TYPE_REF)
/
create index IND_FK_ARG_TO_PLM on i$SDD_ARG(PLSQL_MODULE_REF, parent_ivid)
/
create index IND_FK_ARG_TO_TBL on i$SDD_ARG(TABLE_DEFINITION_REF)
/
create index PK_SDD_ARG_idx on i$SDD_ARG(IRID)
/
create index IND_FK_ARGITE_TO_ARG on i$SDD_ARGITE(MODULE_ARGUMENT_REF, parent_ivid)
/
create index IND_FK_ARGITE_TO_ITE on i$SDD_ARGITE(ITEM_REF)
/
create index PK_SDD_ARGITE_idx on i$SDD_ARGITE(IRID)
/
create index IND_FK_ASS_TO_ASS on i$SDD_ASS(ASSOCIATION_REF)
/
create index IND_FK_ASS_TO_BOB on i$SDD_ASS(BUSINESS_OBJECT_REF)
/
create index IND_FK_ASS_TO_EOC on i$SDD_ASS(ENTITY_OBJECT_REF)
/
create index IND_FK_ASS_TO_FILES on i$SDD_ASS(ICON_FILE_REF)
/
create index IND_FK_ASS_TO_GEC on i$SDD_ASS(GENERIC_CLASS_REF)
/
create index IND_NAME_ASS on i$SDD_ASS(NAME)
/
create index PK_SDD_ASS_idx on i$SDD_ASS(IRID)
/
create index IND_FK_ASSASS_TO_AEN on i$SDD_ASSASS(PART_OF_ASSOC_END_REF, parent_ivid)
/
create index IND_FK_ASSASS_TO_AEN2 on i$SDD_ASSASS(USE_OF_ASSOC_END_REF)
/
create index PK_SDD_ASSASS_idx on i$SDD_ASSASS(IRID)
/
create index IND_FK_ATT_TO_DOM on i$SDD_ATT(DOMAIN_REF)
/
create index IND_FK_ATT_TO_ENT on i$SDD_ATT(ENTITY_REF, parent_ivid)
/
create index IND_SHORT_NAME_ATT on i$SDD_ATT(SHORT_NAME)
/
create index PK_SDD_ATT_idx on i$SDD_ATT(IRID)
/
create index IND_FK_ATV_TO_ARG on i$SDD_ATV(MODULE_ARGUMENT_REF, parent_ivid)
/
create index IND_FK_ATV_TO_ATT on i$SDD_ATV(ATTRIBUTE_REF, parent_ivid)
/
create index IND_FK_ATV_TO_COL on i$SDD_ATV(COLUMN_REF, parent_ivid)
/
create index IND_FK_ATV_TO_DOM on i$SDD_ATV(DOMAIN_REF, parent_ivid)
/
create index IND_FK_ATV_TO_UBI on i$SDD_ATV(UNBOUND_ITEM_REF, parent_ivid)
/
create index IND_SHORT_NAME_ATV on i$SDD_ATV(ABBREVIATION)
/
create index PK_SDD_ATV_idx on i$SDD_ATV(IRID)
/
create index IND_NAME_BAT on i$SDD_BAT(NAME)
/
create index PK_SDD_BAT_idx on i$SDD_BAT(IRID)
/
create index IND_FK_BLI_TO_BAT on i$SDD_BLI(BATCH_REF, parent_ivid)
/
create index IND_FK_BLI_TO_DBU on i$SDD_BLI(DATABASE_USER_REF)
/
create index IND_FK_BLI_TO_GEM on i$SDD_BLI(GENERAL_MODULE_REF)
/
create index PK_SDD_BLI_idx on i$SDD_BLI(IRID)
/
create index IND_FK_BOB_TO_EOC on i$SDD_BOB(ENTITY_OBJECT_REF)
/
create index IND_FK_BOB_TO_FILES on i$SDD_BOB(ICON_FILE_REF)
/
create index IND_FK_BOB_TO_GEC on i$SDD_BOB(GENERIC_CLASS_REF)
/
create index IND_NAME_BOB on i$SDD_BOB(NAME)
/
create index PK_SDD_BOB_idx on i$SDD_BOB(IRID)
/
create index IND_FK_BOBINC_TO_BOB on i$SDD_BOBINC(BUSINESS_OBJECT_REF, parent_ivid)
/
create index IND_FK_BOBINC_TO_INC on i$SDD_BOBINC(INTERFACE_CLASSIFIER_REF)
/
create index PK_SDD_BOBINC_idx on i$SDD_BOBINC(IRID)
/
create index IND_FK_BRL_TO_DBU on i$SDD_BRL(DATABASE_USER_REF)
/
create index IND_FK_BRL_TO_SNI on i$SDD_BRL(SNAPSHOT_REF, parent_ivid)
/
create index IND_FK_BRL_TO_VWI on i$SDD_BRL(VIEW_IMPLEMENTATION_REF, parent_ivid)
/
create index IND_FK_BRL_TO_VWTAB on i$SDD_BRL(RELATION_SELECTION_REF)
/
create index PK_SDD_BRL_idx on i$SDD_BRL(IRID)
/
create index IND_FK_BRU_TO_BAT on i$SDD_BRU(BATCH_REF, parent_ivid)
/
create index PK_SDD_BRU_idx on i$SDD_BRU(IRID)
/
create index IND_FK_BRUBLI_TO_BLI on i$SDD_BRUBLI(BATCHLINE_REF)
/
create index IND_FK_BRUBLI_TO_BRU on i$SDD_BRUBLI(BATCH_RUN_REF, parent_ivid)
/
create index PK_SDD_BRUBLI_idx on i$SDD_BRUBLI(IRID)
/
create index IND_FK_BUN_TO_BUN on i$SDD_BUN(PARENT_REF)
/
create index IND_NAME_BUN on i$SDD_BUN(NAME)
/
create index IND_SHORT_NAME_BUN on i$SDD_BUN(SHORT_NAME)
/
create index PK_SDD_BUN_idx on i$SDD_BUN(IRID)
/
create index IND_FK_CAT_TO_ADC on i$SDD_CAT(ATTRIBUTE_DOMAIN_REF, parent_ivid)
/
create index IND_FK_CAT_TO_CLA on i$SDD_CAT(CLASSIFIER_REF)
/
create index IND_FK_CAT_TO_CLA2 on i$SDD_CAT(COLLECT_CLASSSIFIER_REF)
/
create index IND_FK_CAT_TO_EAT on i$SDD_CAT(EO_ATTRIBUTE_REF)
/
create index IND_FK_CAT_TO_EOC on i$SDD_CAT(ENTITY_OBJECT_REF, parent_ivid)
/
create index IND_FK_CAT_TO_EOU on i$SDD_CAT(ENTITY_OBJECT_USAGE_REF)
/
create index IND_FK_CAT_TO_EVC on i$SDD_CAT(EVENT_CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_CAT_TO_GEC on i$SDD_CAT(GENERIC_CLASS_REF, parent_ivid)
/
create index IND_FK_CAT_TO_INC on i$SDD_CAT(INTERFACE_CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_CAT_TO_VOB on i$SDD_CAT(VIEW_OBJECT_REF, parent_ivid)
/
create index PK_SDD_CAT_idx on i$SDD_CAT(IRID)
/
create index UK_HANDCRAFTED_CAT_idx on i$SDD_CAT(GENERIC_CLASS_REF,EVENT_CLASSIFIER_REF,INTERFACE_CLASSIFIER_REF,ENTITY_OBJECT_REF,VIEW_OBJECT_REF,NAME)
/
create index IND_FK_CATAEN_TO_AEN on i$SDD_CATAEN(ASSOCIATION_END_REF, parent_ivid)
/
create index IND_FK_CATAEN_TO_EAT on i$SDD_CATAEN(EO_ATTRIBUTE_REF)
/
create index IND_FK_CATAEN_TO_GAT on i$SDD_CATAEN(GENERAL_ATTRIBUTE_REF)
/
create index PK_SDD_CATAEN_idx on i$SDD_CATAEN(IRID)
/
create index IND_FK_CATEAT_TO_EAT on i$SDD_CATEAT(EO_ATTRIBUTE_REF)
/
create index IND_FK_CATEAT_TO_GAT on i$SDD_CATEAT(GENERAL_ATTRIBUTE_REF, parent_ivid)
/
create index PK_SDD_CATEAT_idx on i$SDD_CATEAT(IRID)
/
create index IND_FK_CCD_TO_OCL on i$SDD_CCD(CLUSTER_REF, parent_ivid)
/
create index PK_SDD_CCD_idx on i$SDD_CCD(IRID)
/
create index IND_FK_CDE_TO_FILES on i$SDD_CDE(PRIMARY_ACCESS_FILE_REF)
/
create index IND_NAME_CDE on i$SDD_CDE(DEFINITION_TYPE)
/
create index PK_SDD_CDE_idx on i$SDD_CDE(IRID)
/
create index IND_FK_CLA_TO_ACR on i$SDD_CLA(ACTOR_REF)
/
create index IND_FK_CLA_TO_BOB on i$SDD_CLA(BUSINESS_OBJECT_REF)
/
create index IND_FK_CLA_TO_CLA on i$SDD_CLA(CLASSIFIER_REF)
/
create index IND_FK_CLA_TO_FILES on i$SDD_CLA(ICON_FILE_REF)
/
create index IND_FK_CLA_TO_GEC on i$SDD_CLA(GENERIC_CLASS_REF)
/
create index IND_FK_CLA_TO_INC on i$SDD_CLA(INTERFACE_CLASSIFIER_REF)
/
create index IND_FK_CLA_TO_OST on i$SDD_CLA(OBJECT_STATE_REF)
/
create index IND_FK_CLA_TO_USC on i$SDD_CLA(USE_CASE_REF)
/
create index IND_NAME_CLA on i$SDD_CLA(NAME)
/
create index PK_SDD_CLA_idx on i$SDD_CLA(IRID)
/
create index IND_FK_CLAAEN_TO_AEN on i$SDD_CLAAEN(ASSOCIATION_END_REF)
/
create index IND_FK_CLAAEN_TO_INC on i$SDD_CLAAEN(INTERFACE_CLASSIFIER_REF, parent_ivid)
/
create index PK_SDD_CLAAEN_idx on i$SDD_CLAAEN(IRID)
/
create index IND_FK_CLACLA_TO_CLA on i$SDD_CLACLA(SUBTYPE_REF, parent_ivid)
/
create index IND_FK_CLACLA_TO_CLA2 on i$SDD_CLACLA(SUPERTYPE_REF)
/
create index IND_FK_CLACLA_TO_CSG on i$SDD_CLACLA(SPEC_GROUP_REF)
/
create index PK_SDD_CLACLA_idx on i$SDD_CLACLA(IRID)
/
create index UK_CLACLA_2_idx on i$SDD_CLACLA(SUPERTYPE_REF,SEQUENCE)
/
create index IND_FK_CLAEVC_TO_CLA on i$SDD_CLAEVC(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_CLAEVC_TO_EVC on i$SDD_CLAEVC(EVENT_CLASSIFIER_REF)
/
create index PK_SDD_CLAEVC_idx on i$SDD_CLAEVC(IRID)
/
create index IND_FK_CLAINC_TO_CLA on i$SDD_CLAINC(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_CLAINC_TO_INC on i$SDD_CLAINC(INTERFACE_CLASSIFIER_REF)
/
create index PK_SDD_CLAINC_idx on i$SDD_CLAINC(IRID)
/
create index IND_FK_CMA_TO_AEN on i$SDD_CMA(ASSOCIATION_END_REF)
/
create index IND_FK_CMA_TO_CAT on i$SDD_CMA(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_CMA_TO_CAT2 on i$SDD_CMA(CLASSIFIER_ATT_FROM_REF)
/
create index IND_FK_CMA_TO_EVC on i$SDD_CMA(EVENT_CLASSIFIER_REF)
/
create index IND_FK_CMA_TO_EVH on i$SDD_CMA(EVENT_HANDLER_REF, parent_ivid)
/
create index IND_FK_CMA_TO_EVR on i$SDD_CMA(EVENT_RAISER_REF, parent_ivid)
/
create index IND_FK_CMA_TO_EVR2 on i$SDD_CMA(EVENT_RAISER_FROM_REF)
/
create index IND_FK_CMA_TO_MPA on i$SDD_CMA(METHOD_PARAMETER_REF)
/
create index PK_SDD_CMA_idx on i$SDD_CMA(IRID)
/
create index IND_FK_CNU_TO_MTI on i$SDD_CNU(TABLE_USAGE_REF, parent_ivid)
/
create index IND_FK_CNU_TO_OCO on i$SDD_CNU(CONSTRAINT_REF)
/
create index PK_SDD_CNU_idx on i$SDD_CNU(IRID)
/
create index IND_FK_COB_TO_BLI on i$SDD_COB(BATCHLINE_REF, parent_ivid)
/
create index PK_SDD_COB_idx on i$SDD_COB(IRID)
/
create index IND_FK_COL_TO_ATT on i$SDD_COL(SOURCE_ATTRIBUTE_REF)
/
create index IND_FK_COL_TO_CCD on i$SDD_COL(CLUSTER_COLUMN_REF)
/
create index IND_FK_COL_TO_COL on i$SDD_COL(BASE_COLUMN_REF)
/
create index IND_FK_COL_TO_COL2 on i$SDD_COL(COLUMN_DENORMALISED_FROM)
/
create index IND_FK_COL_TO_DOM on i$SDD_COL(DOMAIN_REF)
/
create index IND_FK_COL_TO_JCO on i$SDD_COL(CONSTRAINT_DENORMALISED_VIA)
/
create index IND_FK_COL_TO_OOT on i$SDD_COL(ORACLE_OBJECT_TYPE_REF, parent_ivid)
/
create index IND_FK_COL_TO_ORT on i$SDD_COL(ORACLE_TYPE_REF)
/
create index IND_FK_COL_TO_OSQ on i$SDD_COL(SEQUENCE_REF)
/
create index IND_FK_COL_TO_TAB on i$SDD_COL(TABLE_REF, parent_ivid)
/
create index IND_FK_COL_TO_TBL on i$SDD_COL(SCOPE_TABLE_REF)
/
create index IND_FK_COL_TO_VWTAB on i$SDD_COL(RELATION_SELECTION_REF)
/
create index PK_SDD_COL_idx on i$SDD_COL(IRID)
/
create index IND_NAME_COM on i$SDD_COM(NAME)
/
create index PK_SDD_COM_idx on i$SDD_COM(IRID)
/
create index IND_FK_COMNOD_TO_COM on i$SDD_COMNOD(COMMUNITY_REF, parent_ivid)
/
create index IND_FK_COMNOD_TO_E20 on i$SDD_COMNOD(NODE_REF)
/
create index PK_SDD_COMNOD_idx on i$SDD_COMNOD(IRID)
/
create index IND_FK_COMODB_TO_COM on i$SDD_COMODB(COMMUNITY_REF, parent_ivid)
/
create index IND_FK_COMODB_TO_ORC on i$SDD_COMODB(ORACLE_DATABASE_REF)
/
create index PK_SDD_COMODB_idx on i$SDD_COMODB(IRID)
/
create index IND_NAME_COR on i$SDD_COR(NAME)
/
create index PK_SDD_COR_idx on i$SDD_COR(IRID)
/
create index IND_FK_CORI_TO_CAT on i$SDD_CORI(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_CORI_TO_COR on i$SDD_CORI(CROSS_OBJECT_RULE_REF, parent_ivid)
/
create index IND_FK_CORI_TO_LAN on i$SDD_CORI(LANGUAGE_REF)
/
create index IND_FK_CORI_TO_MET on i$SDD_CORI(METHOD_REF)
/
create index PK_SDD_CORI_idx on i$SDD_CORI(IRID)
/
create index IND_FK_CQA_TO_CCD on i$SDD_CQA(CLUSTER_COLUMN_REF)
/
create index IND_FK_CQA_TO_TBL on i$SDD_CQA(TABLE_DEFINITION_REF, parent_ivid)
/
create index IND_FK_CQA_TO_TBL2 on i$SDD_CQA(SCOPE_TABLE_REF)
/
create index PK_SDD_CQA_idx on i$SDD_CQA(IRID)
/
create index IND_FK_CQACOL_TO_COL on i$SDD_CQACOL(COLUMN_REF)
/
create index IND_FK_CQACOL_TO_CQA on i$SDD_CQACOL(CQA_REF, parent_ivid)
/
create index PK_SDD_CQACOL_idx on i$SDD_CQACOL(IRID)
/
create index IND_FK_CRU_TO_CAT on i$SDD_CRU(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_CRU_TO_EOC on i$SDD_CRU(ENTITY_OBJECT_REF, parent_ivid)
/
create index IND_FK_CRU_TO_GEC on i$SDD_CRU(GENERIC_CLASS_REF, parent_ivid)
/
create index IND_FK_CRU_TO_INC on i$SDD_CRU(INTERFACE_CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_CRU_TO_LAN on i$SDD_CRU(LANGUAGE_REF)
/
create index IND_FK_CRU_TO_MET on i$SDD_CRU(METHOD_REF)
/
create index IND_FK_CRU_TO_VOB on i$SDD_CRU(VIEW_OBJECT_REF, parent_ivid)
/
create index PK_SDD_CRU_idx on i$SDD_CRU(IRID)
/
create index IND_FK_CSG_TO_CLA on i$SDD_CSG(CLASSIFIER_REF, parent_ivid)
/
create index PK_SDD_CSG_idx on i$SDD_CSG(IRID)
/
create index IND_2ND_NAME_CST on i$SDD_CST(LOB_SEGMENT_NAME)
/
create index IND_FK_CST_TO_COL on i$SDD_CST(COLUMN_REF)
/
create index IND_FK_CST_TO_CQA on i$SDD_CST(CQA_REF)
/
create index IND_FK_CST_TO_LST on i$SDD_CST(LOB_STORAGE_REF)
/
create index IND_FK_CST_TO_OSP on i$SDD_CST(STORAGE_DEFINITION_REF)
/
create index IND_FK_CST_TO_OTB on i$SDD_CST(TABLESPACE_REF)
/
create index IND_FK_CST_TO_TBI on i$SDD_CST(TABLE_IMPLEMENTATION_REF, parent_ivid)
/
create index PK_SDD_CST_idx on i$SDD_CST(IRID)
/
create index IND_FK_DAT_TO_PLM on i$SDD_DAT(PLSQL_MODULE_REF, parent_ivid)
/
create index PK_SDD_DAT_idx on i$SDD_DAT(IRID)
/
create index IND_FK_DATCOM_TO_AEN on i$SDD_DATCOM(ASSOCIATION_END_REF)
/
create index IND_FK_DATCOM_TO_ARR on i$SDD_DATCOM(ARC_RULE_REF, parent_ivid)
/
create index IND_FK_DATCOM_TO_CAT on i$SDD_DATCOM(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_DATCOM_TO_UNR on i$SDD_DATCOM(UNIQUENESS_RULE_REF, parent_ivid)
/
create index PK_SDD_DATCOM_idx on i$SDD_DATCOM(IRID)
/
create index IND_FK_DBU_TO_DPR on i$SDD_DBU(DATABASE_PROFILE_REF)
/
create index IND_FK_DBU_TO_ODB on i$SDD_DBU(DATABASE_REF, parent_ivid)
/
create index IND_FK_DBU_TO_OTB on i$SDD_DBU(DEFAULT_TABLESPACE_REF)
/
create index IND_FK_DBU_TO_OTB2 on i$SDD_DBU(TEMP_TABLESPACE_REF)
/
create index IND_NAME_DBU on i$SDD_DBU(NAME)
/
create index PK_SDD_DBU_idx on i$SDD_DBU(IRID)
/
create index IND_FK_DBUGRP_TO_DBU on i$SDD_DBUGRP(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_DBUGRP_TO_GRP on i$SDD_DBUGRP(ROLE_REF)
/
create index PK_SDD_DBUGRP_idx on i$SDD_DBUGRP(IRID)
/
create index IND_FK_DBUMOD_TO_DBU on i$SDD_DBUMOD(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_DBUMOD_TO_GEM on i$SDD_DBUMOD(GENERAL_MODULE_REF)
/
create index PK_SDD_DBUMOD_idx on i$SDD_DBUMOD(IRID)
/
create index IND_FK_DEU_TO_DIA on i$SDD_DEU(DIAGRAM_REF, parent_ivid)
/
create index PK_SDD_DEU_idx on i$SDD_DEU(IRID)
/
create index IND_FK_DFI_TO_ORC on i$SDD_DFI(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_FK_DFI_TO_OTB on i$SDD_DFI(TABLESPACE_REF, parent_ivid)
/
create index PK_SDD_DFI_idx on i$SDD_DFI(IRID)
/
create index IND_FK_DFL_TO_DST on i$SDD_DFL(DATASTORE_SOURCE_REF, parent_ivid)
/
create index IND_FK_DFL_TO_DST2 on i$SDD_DFL(DATASTORE_DEST_REF)
/
create index IND_FK_DFL_TO_EXT on i$SDD_DFL(EXTERNAL_SOURCE_REF, parent_ivid)
/
create index IND_FK_DFL_TO_EXT2 on i$SDD_DFL(EXTERNAL_DEST_REF)
/
create index IND_FK_DFL_TO_FUN on i$SDD_DFL(FUNCTION_SOURCE_REF, parent_ivid)
/
create index IND_FK_DFL_TO_FUN2 on i$SDD_DFL(FUNCTION_DEST_REF)
/
create index PK_SDD_DFL_idx on i$SDD_DFL(IRID)
/
create index IND_FK_DFLATT_TO_ATT on i$SDD_DFLATT(ATTRIBUTE_REF)
/
create index IND_FK_DFLATT_TO_DFL on i$SDD_DFLATT(DATAFLOW_REF, parent_ivid)
/
create index PK_SDD_DFLATT_idx on i$SDD_DFLATT(IRID)
/
create index IND_FK_DFLDIT_TO_DFL on i$SDD_DFLDIT(DATAFLOW_REF, parent_ivid)
/
create index IND_FK_DFLDIT_TO_DIT on i$SDD_DFLDIT(DATA_ITEM_REF)
/
create index PK_SDD_DFLDIT_idx on i$SDD_DFLDIT(IRID)
/
create index IND_FK_DIA_TO_PCK on i$SDD_DIA(PACKAGE_REF)
/
create index IND_NAME_DIA on i$SDD_DIA(NAME)
/
create index PK_SDD_DIA_idx on i$SDD_DIA(IRID)
/
create index IND_FK_SEG_TO_DIA on i$SDD_DIAGRAM_SEGMENTS(DIAGRAM_REF, parent_ivid)
/
create index PK_SDD_DIAGRAM_SEGMENTS_idx on i$SDD_DIAGRAM_SEGMENTS(IRID)
/
create index IND_FK_DIR_TO_ORC on i$SDD_DIR(ORACLE_DATABASE_REF, parent_ivid)
/
create index PK_SDD_DIR_idx on i$SDD_DIR(IRID)
/
create index IND_NAME_DIT on i$SDD_DIT(NAME)
/
create index PK_SDD_DIT_idx on i$SDD_DIT(IRID)
/
create index IND_AUTHORIZATION_ID_DOC on i$SDD_DOC(AUTHORISATION_ID)
/
create index IND_NAME_DOC on i$SDD_DOC(NAME)
/
create index PK_SDD_DOC_idx on i$SDD_DOC(IRID)
/
create index IND_FK_DOCXXX_TO_DOC on i$SDD_DOCXXX(DOCUMENT_REF, parent_ivid)
/
create index PK_SDD_DOCXXX_idx on i$SDD_DOCXXX(IRID)
/
create index IND_FK_DOG_TO_DBU on i$SDD_DOG(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_DOG_TO_DIR on i$SDD_DOG(DIRECTORY_REF)
/
create index IND_FK_DOG_TO_GRP on i$SDD_DOG(ROLE_REF, parent_ivid)
/
create index IND_FK_DOG_TO_JMI on i$SDD_DOG(JMI_REF)
/
create index IND_FK_DOG_TO_PMI on i$SDD_DOG(PLSQL_MODULE_REF)
/
create index IND_FK_DOG_TO_QUI on i$SDD_DOG(QUI_REF)
/
create index IND_FK_DOG_TO_SNI on i$SDD_DOG(SNAPSHOT_REF)
/
create index IND_FK_DOG_TO_SQI on i$SDD_DOG(SEQUENCE_REF)
/
create index IND_FK_DOG_TO_TBI on i$SDD_DOG(TABLE_REF)
/
create index IND_FK_DOG_TO_VWI on i$SDD_DOG(VIEW_REF)
/
create index PK_SDD_DOG_idx on i$SDD_DOG(IRID)
/
create index IND_FK_DOI_TO_DBU on i$SDD_DOI(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_DOI_TO_DBU2 on i$SDD_DOI(DATABASE_USER_REF2)
/
create index IND_FK_DOI_TO_DBU3 on i$SDD_DOI(ORACLE_TYPE_DBU_REF)
/
create index IND_FK_DOI_TO_DIR on i$SDD_DOI(DIRECTORY_REF)
/
create index IND_FK_DOI_TO_JAM on i$SDD_DOI(JAVA_MODULE_REF)
/
create index IND_FK_DOI_TO_OCL on i$SDD_DOI(CLUSTER_REF)
/
create index IND_FK_DOI_TO_OSP on i$SDD_DOI(STORAGE_DEFINITION_REF)
/
create index IND_FK_DOI_TO_OSP2 on i$SDD_DOI(SNAP_LOG_STORAGE_REF)
/
create index IND_FK_DOI_TO_OSQ on i$SDD_DOI(SEQUENCE_REF)
/
create index IND_FK_DOI_TO_OTB on i$SDD_DOI(TABLESPACE_REF)
/
create index IND_FK_DOI_TO_OTB2 on i$SDD_DOI(OVERFLOW_TABLESPACE_REF)
/
create index IND_FK_DOI_TO_OTB3 on i$SDD_DOI(SNAP_LOG_TABLESPACE_REF)
/
create index IND_FK_DOI_TO_PLM on i$SDD_DOI(PLSQL_MODULE_REF)
/
create index IND_FK_DOI_TO_QTD on i$SDD_DOI(QUEUE_TABLE_DEF_REF)
/
create index IND_FK_DOI_TO_RPG on i$SDD_DOI(REPLICATION_GROUP_REF)
/
create index IND_FK_DOI_TO_SNP on i$SDD_DOI(SNAPSHOT_DEFINITION_REF)
/
create index IND_FK_DOI_TO_SRG on i$SDD_DOI(SNAPSHOT_GROUP_REF)
/
create index IND_FK_DOI_TO_TBL on i$SDD_DOI(TABLE_DEFINITION_REF)
/
create index IND_FK_DOI_TO_VW on i$SDD_DOI(VIEW_DEFINITION_REF)
/
create index PK_SDD_DOI_idx on i$SDD_DOI(IRID)
/
create index IND_FK_DOM_TO_DOM on i$SDD_DOM(SUPERTYPE_REF)
/
create index IND_NAME_DOM on i$SDD_DOM(NAME)
/
create index PK_SDD_DOM_idx on i$SDD_DOM(IRID)
/
create index IND_FK_DPR_TO_ORC on i$SDD_DPR(ORACLE_DATABASE_REF, parent_ivid)
/
create index PK_SDD_DPR_idx on i$SDD_DPR(IRID)
/
create index IND_FK_DST_TO_BUN on i$SDD_DST(BUSINESS_UNIT_REF)
/
create index IND_FK_DST_TO_FUN on i$SDD_DST(FUNCTION_REF)
/
create index IND_NAME_DST on i$SDD_DST(NAME)
/
create index IND_SHORT_NAME_DST on i$SDD_DST(SHORT_IDENTIFIER)
/
create index PK_SDD_DST_idx on i$SDD_DST(IRID)
/
create index IND_FK_DSTATT_TO_ATT on i$SDD_DSTATT(ATTRIBUTE_REF)
/
create index IND_FK_DSTATT_TO_DST on i$SDD_DSTATT(DATASTORE_REF, parent_ivid)
/
create index PK_SDD_DSTATT_idx on i$SDD_DSTATT(IRID)
/
create index IND_FK_DSTDIT_TO_DIT on i$SDD_DSTDIT(DATA_ITEM_REF)
/
create index IND_FK_DSTDIT_TO_DST on i$SDD_DSTDIT(DATASTORE_REF, parent_ivid)
/
create index PK_SDD_DSTDIT_idx on i$SDD_DSTDIT(IRID)
/
create index IND_FK_DSY_TO_JAM on i$SDD_DSY(JAVA_MODULE_REF, parent_ivid)
/
create index IND_FK_DSY_TO_OSQ on i$SDD_DSY(SEQUENCE_REF, parent_ivid)
/
create index IND_FK_DSY_TO_PLM on i$SDD_DSY(PLSQL_MODULE_REF, parent_ivid)
/
create index IND_FK_DSY_TO_SNP on i$SDD_DSY(SNAPSHOT_DEFINITION_REF, parent_ivid)
/
create index IND_FK_DSY_TO_TBL on i$SDD_DSY(TABLE_DEFINITION_REF, parent_ivid)
/
create index IND_FK_DSY_TO_VW on i$SDD_DSY(VIEW_DEFINITION_REF, parent_ivid)
/
create index IND_NAME_DSY on i$SDD_DSY(NAME)
/
create index PK_SDD_DSY_idx on i$SDD_DSY(IRID)
/
create index IND_FK_E1_TO_E1 on i$SDD_E1(OBJECTIVE_REF)
/
create index IND_NAME_E1 on i$SDD_E1(NAME)
/
create index PK_SDD_E1_idx on i$SDD_E1(IRID)
/
create index IND_FK_E2_TO_E2 on i$SDD_E2(CSF_REF)
/
create index IND_NAME_E2 on i$SDD_E2(NAME)
/
create index PK_SDD_E2_idx on i$SDD_E2(IRID)
/
create index IND_NAME_E20 on i$SDD_E20(NAME)
/
create index PK_SDD_E20_idx on i$SDD_E20(IRID)
/
create index IND_FK_E3_TO_E3 on i$SDD_E3(KPI_REF)
/
create index IND_NAME_E3 on i$SDD_E3(NAME)
/
create index PK_SDD_E3_idx on i$SDD_E3(IRID)
/
create index IND_NAME_E4 on i$SDD_E4(NAME)
/
create index PK_SDD_E4_idx on i$SDD_E4(IRID)
/
create index IND_FK_E5_TO_E5 on i$SDD_E5(PROBLEM_REF)
/
create index IND_NAME_E5 on i$SDD_E5(NAME)
/
create index PK_SDD_E5_idx on i$SDD_E5(IRID)
/
create index IND_FK_E6_TO_E6 on i$SDD_E6(LOCATION_REF)
/
create index IND_NAME_E6 on i$SDD_E6(NAME)
/
create index PK_SDD_E6_idx on i$SDD_E6(IRID)
/
create index IND_FK_ENT_TO_ENT on i$SDD_ENT(SUPERTYPE_REF)
/
create index IND_NAME_ENT on i$SDD_ENT(NAME)
/
create index IND_SHORT_NAME_ENT on i$SDD_ENT(SHORT_NAME)
/
create index PK_SDD_ENT_idx on i$SDD_ENT(IRID)
/
create index IND_FK_ENTBUN_TO_BUN on i$SDD_ENTBUN(BUSINESS_UNIT_REF)
/
create index IND_FK_ENTBUN_TO_ENT on i$SDD_ENTBUN(ENTITY_REF, parent_ivid)
/
create index PK_SDD_ENTBUN_idx on i$SDD_ENTBUN(IRID)
/
create index IND_FK_ENTUIE_TO_ATT on i$SDD_ENTUIE(ATTRIBUTE_REF)
/
create index IND_FK_ENTUIE_TO_RELEND on i$SDD_ENTUIE(RELATIONSHIP_END_REF)
/
create index IND_FK_ENTUIE_TO_UID on i$SDD_ENTUIE(UNIQUE_IDENTIFIER_REF, parent_ivid)
/
create index PK_SDD_ENTUIE_idx on i$SDD_ENTUIE(IRID)
/
create index IND_FK_EOU_TO_EOC on i$SDD_EOU(ENTITY_OBJECT_REF)
/
create index IND_FK_EOU_TO_VOB on i$SDD_EOU(VIEW_OBJECT_REF, parent_ivid)
/
create index PK_SDD_EOU_idx on i$SDD_EOU(IRID)
/
create index IND_FK_ERU_TO_URU on i$SDD_ERU(UML_RULE_REF)
/
create index PK_SDD_ELRUL_idx on i$SDD_ERU(IRID)
/
create index UK_ERU_idx on i$SDD_ERU(CIELEMENT_REF,UML_RULE_REF)
/
create index IND_FK_EVH_TO_EVS on i$SDD_EVH(EVENT_SUBSCRIPTION_REF)
/
create index IND_FK_EVH_TO_MET on i$SDD_EVH(METHOD_REF, parent_ivid)
/
create index IND_FK_EVH_TO_SUD on i$SDD_EVH(SUBSCRIPTION_DETAIL_REF)
/
create index PK_SDD_EVH_idx on i$SDD_EVH(IRID)
/
create index IND_FK_EVR_TO_CLAEVC on i$SDD_EVR(EVENT_PUBLICATION_REF)
/
create index IND_FK_EVR_TO_MET on i$SDD_EVR(METHOD_REF, parent_ivid)
/
create index PK_SDD_EVR_idx on i$SDD_EVR(IRID)
/
create index IND_FK_EVS_TO_CLA on i$SDD_EVS(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_EVS_TO_EVC on i$SDD_EVS(EVENT_CLASSIFIER_REF)
/
create index PK_SDD_EVS_idx on i$SDD_EVS(IRID)
/
create index IND_FK_EVT_TO_ATT on i$SDD_EVT(ATTRIBUTE_REF)
/
create index IND_FK_EVT_TO_ENT on i$SDD_EVT(ENTITY_REF)
/
create index IND_NAME_EVT on i$SDD_EVT(NAME)
/
create index PK_SDD_EVT_idx on i$SDD_EVT(IRID)
/
create index IND_FK_EXT_TO_BUN on i$SDD_EXT(BUSINESS_UNIT_REF)
/
create index IND_FK_EXT_TO_ENT on i$SDD_EXT(ENTITY_REF)
/
create index IND_NAME_EXT on i$SDD_EXT(NAME)
/
create index IND_SHORT_NAME_EXT on i$SDD_EXT(SHORT_IDENTIFIER)
/
create index PK_SDD_EXT_idx on i$SDD_EXT(IRID)
/
create index IND_FK_FIL_TO_LAN on i$SDD_FIL(LANGUAGE_REF)
/
create index IND_NAME_FIL on i$SDD_FIL(NAME)
/
create index PK_SDD_FIL_idx on i$SDD_FIL(IRID)
/
create index IND_NAME_FILES on i$SDD_FILES(NAME)
/
create index PK_SDD_FILES_idx on i$SDD_FILES(IRID)
/
create index IND_FK_FILPAC_TO_ASS on i$SDD_FILPAC(ASSOCIATION_REF, parent_ivid)
/
create index IND_FK_FILPAC_TO_CLA on i$SDD_FILPAC(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_FILPAC_TO_DIA on i$SDD_FILPAC(DIAGRAM_REF, parent_ivid)
/
create index IND_FK_FILPAC_TO_FILES on i$SDD_FILPAC(PRIMARY_ACCESS_FILE_REF)
/
create index IND_FK_FILPAC_TO_VLI on i$SDD_FILPAC(VIEW_LINK_REF, parent_ivid)
/
create index PK_SDD_FILPAC_idx on i$SDD_FILPAC(IRID)
/
create index FOLDER_ROOT_FLAG_IND on i$SDD_FOLDERS(ROOT_FLAG)
/
create index IND_FK_CEL_TO_CLA on i$SDD_FOLDERS(CLASSIFIER_REF)
/
create index IND_FK_CEL_TO_COS on i$SDD_FOLDERS(CODING_STANDARD_REF)
/
create index IND_FK_CEL_TO_FILES on i$SDD_FOLDERS(ICON_FILE_REF)
/
create index IND_FK_CEL_TO_LAN on i$SDD_FOLDERS(LANGUAGE_REF)
/
create index IND_FK_CEL_TO_TRS on i$SDD_FOLDERS(TRANSFORMER_STANDARD_REF)
/
create index IND_SDD_FOLDERS_NAME on i$SDD_FOLDERS(NAME)
/
create index IND_SDD_FOLDERS_OWNING_USER on i$SDD_FOLDERS(OWNING_USER)
/
create index PK_SDD_FOLDERS_idx on i$SDD_FOLDERS(IRID)
/
create index IND_FK_FM_TO_FOLDER on i$SDD_FOLDER_MEMBERS(FOLDER_REFERENCE, parent_ivid)
/
create index IND_SDD_FM_1 on i$SDD_FOLDER_MEMBERS(MEMBER_OBJECT,FOLDER_REFERENCE)
/
create index IND_SDD_FM_PRIME on i$SDD_FOLDER_MEMBERS(FOLDER_REFERENCE,MEMBER_OBJECT)
/
create index PK_FOLDER_MEMBERS_idx on i$SDD_FOLDER_MEMBERS(IRID)
/
create index IND_FK_FSE_TO_CLA on i$SDD_FSE(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_FSE_TO_FILES on i$SDD_FSE(PRIMARY_ACCESS_FILE_REF)
/
create index PK_SDD_FSE_idx on i$SDD_FSE(IRID)
/
create index IND_FK_FUN_TO_FUN on i$SDD_FUN(PARENT_REF)
/
create index IND_FK_FUN_TO_FUN2 on i$SDD_FUN(COMMON_FUNCTION_REF)
/
create index IND_NAME_FUN on i$SDD_FUN(FUNCTION_LABEL)
/
create index PK_SDD_FUN_idx on i$SDD_FUN(IRID)
/
create index IND_FK_FUNATT_TO_ATT on i$SDD_FUNATT(ATTRIBUTE_REF)
/
create index IND_FK_FUNATT_TO_FUN on i$SDD_FUNATT(FUNCTION_REF, parent_ivid)
/
create index IND_FK_FUNATT_TO_FUNENT on i$SDD_FUNATT(FUNENT_REF)
/
create index PK_SDD_FUNATT_idx on i$SDD_FUNATT(IRID)
/
create index IND_FK_FUNBUN_TO_BUN on i$SDD_FUNBUN(BUSINESS_UNIT_REF)
/
create index IND_FK_FUNBUN_TO_FUN on i$SDD_FUNBUN(FUNCTION_REF, parent_ivid)
/
create index PK_SDD_FUNBUN_idx on i$SDD_FUNBUN(IRID)
/
create index IND_FK_FUNENT_TO_ENT on i$SDD_FUNENT(ENTITY_REF)
/
create index IND_FK_FUNENT_TO_FUN on i$SDD_FUNENT(FUNCTION_REF, parent_ivid)
/
create index PK_SDD_FUNENT_idx on i$SDD_FUNENT(IRID)
/
create index IND_FK_FUNEVT_TO_EVT on i$SDD_FUNEVT(TRIGGERING_EVENT_REF)
/
create index IND_FK_FUNEVT_TO_EVT2 on i$SDD_FUNEVT(TRIGGERED_EVENT_REF, parent_ivid)
/
create index IND_FK_FUNEVT_TO_FUN on i$SDD_FUNEVT(TRIGGERING_FUNCTION_REF)
/
create index IND_FK_FUNEVT_TO_FUN2 on i$SDD_FUNEVT(TRIGGERED_FUNCTION_REF, parent_ivid)
/
create index PK_SDD_FUNEVT_idx on i$SDD_FUNEVT(IRID)
/
create index IND_FK_GRP_TO_ORC on i$SDD_GRP(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_NAME_GRP on i$SDD_GRP(NAME)
/
create index PK_SDD_GRP_idx on i$SDD_GRP(IRID)
/
create index IND_FK_GRPGRP_TO_GRP on i$SDD_GRPGRP(GRANTOR_ROLE_REF)
/
create index IND_FK_GRPGRP_TO_GRP2 on i$SDD_GRPGRP(GRANTEE_ROLE_REF, parent_ivid)
/
create index PK_SDD_GRPGRP_idx on i$SDD_GRPGRP(IRID)
/
create index IND_FK_GRPMOD_TO_GEM on i$SDD_GRPMOD(GENERAL_MODULE_REF)
/
create index IND_FK_GRPMOD_TO_GRP on i$SDD_GRPMOD(ROLE_REF, parent_ivid)
/
create index PK_SDD_GRPMOD_idx on i$SDD_GRPMOD(IRID)
/
create index IND_FK_IGR_TO_IGR on i$SDD_IGR(ITEM_GROUP_REF)
/
create index IND_FK_IGR_TO_MCO on i$SDD_IGR(MODULE_COMPONENT_REF, parent_ivid)
/
create index IND_FK_IGR_TO_SUB on i$SDD_IGR(SUBCOMPONENT_REF, parent_ivid)
/
create index PK_SDD_IGR_idx on i$SDD_IGR(IRID)
/
create index IND_FK_IND_TO_FCO on i$SDD_IND(FOREIGN_KEY_REF)
/
create index IND_FK_IND_TO_OCL on i$SDD_IND(CLUSTER_REF, parent_ivid)
/
create index IND_FK_IND_TO_SNP on i$SDD_IND(SNAPSHOT_DEFINITION_REF, parent_ivid)
/
create index IND_FK_IND_TO_TBL on i$SDD_IND(TABLE_DEFINITION_REF, parent_ivid)
/
create index IND_NAME_IND on i$SDD_IND(NAME)
/
create index PK_SDD_IND_idx on i$SDD_IND(IRID)
/
create index IND_FK_INDCOL_TO_COL on i$SDD_INDCOL(COLUMN_REF)
/
create index IND_FK_INDCOL_TO_CQA on i$SDD_INDCOL(CQA_REF)
/
create index IND_FK_INDCOL_TO_RIN on i$SDD_INDCOL(RELATION_INDEX_REF, parent_ivid)
/
create index IND_NAME_INDCOL on i$SDD_INDCOL(NAME)
/
create index PK_SDD_INDCOL_idx on i$SDD_INDCOL(IRID)
/
create index IND_FK_INP_TO_INS on i$SDD_INP(INDEX_STORAGE_REF, parent_ivid)
/
create index IND_FK_INP_TO_OSP on i$SDD_INP(STORAGE_DEFINITION_REF)
/
create index IND_FK_INP_TO_OTB on i$SDD_INP(TABLESPACE_REF)
/
create index IND_FK_INP_TO_TBP on i$SDD_INP(TABLE_PARTITION_REF)
/
create index PK_SDD_INP_idx on i$SDD_INP(IRID)
/
create index IND_FK_INS_TO_CLI on i$SDD_INS(CLUSTER_REF, parent_ivid)
/
create index IND_FK_INS_TO_IND on i$SDD_INS(INDEX_REF)
/
create index IND_FK_INS_TO_OSP on i$SDD_INS(STORAGE_DEFINITION_REF)
/
create index IND_FK_INS_TO_OTB on i$SDD_INS(TABLESPACE_REF)
/
create index IND_FK_INS_TO_PCO on i$SDD_INS(PRIMARY_KEY_REF)
/
create index IND_FK_INS_TO_SNI on i$SDD_INS(SNAPSHOT_REF, parent_ivid)
/
create index IND_FK_INS_TO_TBI on i$SDD_INS(TABLE_IMPLEMENTATION_REF, parent_ivid)
/
create index IND_FK_INS_TO_UCO on i$SDD_INS(UNIQUE_KEY_REF)
/
create index IND_NAME_INS on i$SDD_INS(NAME)
/
create index PK_SDD_INS_idx on i$SDD_INS(IRID)
/
create index IND_FK_ITE_TO_COL on i$SDD_ITE(COLUMN_REF)
/
create index IND_FK_ITE_TO_DOM on i$SDD_ITE(DOMAIN_REF)
/
create index IND_FK_ITE_TO_IGR on i$SDD_ITE(ITEM_GROUP_REF)
/
create index IND_FK_ITE_TO_MTI on i$SDD_ITE(DETAIL_TABLE_USAGE_REF)
/
create index IND_FK_ITE_TO_MUN on i$SDD_ITE(MODULE_UNIT_REF, parent_ivid)
/
create index IND_FK_ITE_TO_SQS on i$SDD_ITE(SQL_QUERY_SET_REF, parent_ivid)
/
create index PK_SDD_ITE_idx on i$SDD_ITE(IRID)
/
create index IND_FK_ITM_TO_COL on i$SDD_ITM(COLUMN_REF)
/
create index IND_FK_ITM_TO_CQA on i$SDD_ITM(CQA_REF)
/
create index IND_FK_ITM_TO_DAT on i$SDD_ITM(DATASTRUCTURE_REF, parent_ivid)
/
create index IND_FK_ITM_TO_DAT2 on i$SDD_ITM(DATASTRUCTURE_REF2)
/
create index IND_FK_ITM_TO_DOM on i$SDD_ITM(DOMAIN_REF)
/
create index IND_FK_ITM_TO_ORT on i$SDD_ITM(ORACLE_TYPE_REF)
/
create index IND_FK_ITM_TO_PGD on i$SDD_ITM(PROGRAM_DATUM_REF)
/
create index IND_FK_ITM_TO_PLM on i$SDD_ITM(PLSQL_MODULE_REF)
/
create index IND_FK_ITM_TO_PLM2 on i$SDD_ITM(CURSOR_REF)
/
create index IND_FK_ITM_TO_TBL on i$SDD_ITM(TABLE_DEFINITION_REF)
/
create index PK_SDD_ITM_idx on i$SDD_ITM(IRID)
/
create index IND_NAME_LAN on i$SDD_LAN(NAME)
/
create index PK_SDD_LAN_idx on i$SDD_LAN(IRID)
/
create index IND_FK_LST_TO_ORC on i$SDD_LST(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_FK_LST_TO_OSP on i$SDD_LST(STORAGE_DEFINITION_REF)
/
create index IND_FK_LST_TO_OSP2 on i$SDD_LST(INDEX_STORAGE_DEFN_REF)
/
create index IND_FK_LST_TO_OTB on i$SDD_LST(TABLESPACE_REF)
/
create index IND_FK_LST_TO_OTB2 on i$SDD_LST(INDEX_TABLESPACE_REF)
/
create index PK_SDD_LST_idx on i$SDD_LST(IRID)
/
create index IND_FK_LVI_TO_GEM on i$SDD_LVI(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_LVI_TO_ITE on i$SDD_LVI(ITEM_REF)
/
create index IND_FK_LVI_TO_LOV on i$SDD_LVI(LIST_OF_VALUES_REF)
/
create index PK_SDD_LVI_idx on i$SDD_LVI(IRID)
/
create index IND_FK_MAP_TO_MAP on i$SDD_MAP(PRIMARY_MAPPING_REF)
/
create index IND_FK_MAP_TO_TMS on i$SDD_MAP(TRANSFORMATION_SET_REF, parent_ivid)
/
create index PK_SDD_MAP_idx on i$SDD_MAP(IRID)
/
create index IND_FK_MCH_TO_MOD on i$SDD_MCH(MODULE_REF, parent_ivid)
/
create index PK_SDD_MCH_idx on i$SDD_MCH(IRID)
/
create index IND_FK_MCL_TO_GEM on i$SDD_MCL(MODULE_REF_FROM, parent_ivid)
/
create index IND_FK_MCL_TO_GEM2 on i$SDD_MCL(MODULE_REF_TO)
/
create index IND_FK_MCL_TO_JCO on i$SDD_MCL(JOIN_CONSTRAINT_REF)
/
create index IND_FK_MCL_TO_MCN on i$SDD_MCL(MCN_REF_FROM)
/
create index IND_FK_MCL_TO_MCN2 on i$SDD_MCL(MCN_REF_TO)
/
create index IND_FK_MCL_TO_MTI on i$SDD_MCL(TABLE_USAGE_REF_FROM)
/
create index IND_FK_MCL_TO_MTI2 on i$SDD_MCL(TABLE_USAGE_REF_TO)
/
create index IND_FK_MCL_TO_PCO on i$SDD_MCL(PRIMARY_KEY_REF)
/
create index PK_SDD_MCL_idx on i$SDD_MCL(IRID)
/
create index UK_MCL_idx on i$SDD_MCL(MCN_REF_FROM,MCN_REF_TO)
/
create index IND_FK_MCN_TO_GEM on i$SDD_MCN(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_MCN_TO_MCN on i$SDD_MCN(PARENT_MCN_REF)
/
create index IND_FK_MCN_TO_MCN2 on i$SDD_MCN(RIGHT_OF_MCN_REF)
/
create index IND_FK_MCN_TO_MCO on i$SDD_MCN(MODULE_COMPONENT_REF)
/
create index IND_FK_MCN_TO_SUB on i$SDD_MCN(SUBCOMPONENT_REF)
/
create index IND_FK_MCN_TO_WIN on i$SDD_MCN(WINDOW_REF)
/
create index PK_SDD_MCN_idx on i$SDD_MCN(IRID)
/
create index IND_FK_MEMCOM_TO_ADR on i$SDD_MEMCOM(ATTRIBUTE_DERIV_RULE_REF, parent_ivid)
/
create index IND_FK_MEMCOM_TO_AEN on i$SDD_MEMCOM(ASSOCIATION_END_REF)
/
create index IND_FK_MEMCOM_TO_CAT on i$SDD_MEMCOM(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_MEMCOM_TO_COR on i$SDD_MEMCOM(CROSS_OBJECT_RULE_REF, parent_ivid)
/
create index IND_FK_MEMCOM_TO_INR on i$SDD_MEMCOM(INTEGRITY_RULE_REF, parent_ivid)
/
create index IND_FK_MEMCOM_TO_MET on i$SDD_MEMCOM(METHOD_REF)
/
create index IND_FK_MEMCOM_TO_RUL on i$SDD_MEMCOM(NAMED_RULE_REF, parent_ivid)
/
create index IND_FK_MEMCOM_TO_SRU on i$SDD_MEMCOM(STATE_RULE_REF, parent_ivid)
/
create index PK_SDD_MEMCOM_idx on i$SDD_MEMCOM(IRID)
/
create index IND_FK_MET_TO_CLA on i$SDD_MET(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_MET_TO_CLA2 on i$SDD_MET(RETURN_CLASSIFIER_REF)
/
create index IND_FK_MET_TO_CLA3 on i$SDD_MET(COLLECT_CLASSIFIER_REF)
/
create index IND_FK_MET_TO_MET on i$SDD_MET(ELEVATED_METHOD_REF)
/
create index IND_FK_MET_TO_MET2 on i$SDD_MET(OVERRIDING_METHOD_REF)
/
create index IND_NAME_MET on i$SDD_MET(NAME)
/
create index PK_SDD_MET_idx on i$SDD_MET(IRID)
/
create index IND_FK_METRUL_TO_ADR on i$SDD_METRUL(ATTRIBUTE_DERIV_RULE_REF)
/
create index IND_FK_METRUL_TO_COR on i$SDD_METRUL(CROSS_OBJECT_RULE_REF)
/
create index IND_FK_METRUL_TO_CRU on i$SDD_METRUL(CLASSIFIER_RULE_REF)
/
create index IND_FK_METRUL_TO_MET on i$SDD_METRUL(METHOD_REF, parent_ivid)
/
create index IND_FK_METRUL_TO_RUL on i$SDD_METRUL(NAMED_RULE_REF)
/
create index IND_FK_METRUL_TO_SRU on i$SDD_METRUL(STATE_RULE_REF)
/
create index PK_SDD_METRUL_idx on i$SDD_METRUL(IRID)
/
create index IND_FK_MOD_TO_JAM on i$SDD_MOD(JAVA_MODULE_REF)
/
create index IND_FK_MOD_TO_LAN on i$SDD_MOD(LANGUAGE_REF)
/
create index IND_FK_MOD_TO_OOT on i$SDD_MOD(ORACLE_OBJECT_TYPE_REF, parent_ivid)
/
create index IND_FK_MOD_TO_ORT on i$SDD_MOD(ORACLE_TYPE_REF)
/
create index IND_NAME_MOD on i$SDD_MOD(NAME)
/
create index IND_SHORT_NAME_MOD on i$SDD_MOD(SHORT_NAME)
/
create index PK_SDD_MOD_idx on i$SDD_MOD(IRID)
/
create index IND_FK_MODBUN_TO_BUN on i$SDD_MODBUN(BUSINESS_UNIT_REF)
/
create index IND_FK_MODBUN_TO_MOD on i$SDD_MODBUN(MODULE_REF, parent_ivid)
/
create index PK_SDD_MODBUN_idx on i$SDD_MODBUN(IRID)
/
create index IND_FK_MODFUN_TO_FUN on i$SDD_MODFUN(FUNCTION_REF)
/
create index IND_FK_MODFUN_TO_MOD on i$SDD_MODFUN(MODULE_REF, parent_ivid)
/
create index PK_SDD_MODFUN_idx on i$SDD_MODFUN(IRID)
/
create index IND_FK_MODMOD_TO_MOD on i$SDD_MODMOD(PARENT_MODULE_REF, parent_ivid)
/
create index IND_FK_MODMOD_TO_MOD2 on i$SDD_MODMOD(CHILD_MODULE_REF)
/
create index PK_SDD_MODMOD_idx on i$SDD_MODMOD(IRID)
/
create index IND_FK_MODPGD_TO_GEM on i$SDD_MODPGD(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_MODPGD_TO_PGD on i$SDD_MODPGD(PROGRAM_DATUM_REF)
/
create index IND_FK_MODPGD_TO_PLM on i$SDD_MODPGD(PLSQL_MODULE_REF, parent_ivid)
/
create index PK_SDD_MODPGD_idx on i$SDD_MODPGD(IRID)
/
create index IND_FK_MPA_TO_CLA on i$SDD_MPA(CLASSIFIER_REF)
/
create index IND_FK_MPA_TO_CLA2 on i$SDD_MPA(COLLECT_CLASSIFIER_REF)
/
create index IND_FK_MPA_TO_MET on i$SDD_MPA(METHOD_REF, parent_ivid)
/
create index PK_SDD_MPA_idx on i$SDD_MPA(IRID)
/
create index IND_FK_MTI_TO_JCO on i$SDD_MTI(CONSTRAINT_REF)
/
create index IND_FK_MTI_TO_JCO2 on i$SDD_MTI(CONSTRAINT_REF2)
/
create index IND_FK_MTI_TO_JCO3 on i$SDD_MTI(TREEWALK_JOIN_CONSTRAINT)
/
create index IND_FK_MTI_TO_MTI on i$SDD_MTI(MTI_REF)
/
create index IND_FK_MTI_TO_MUN on i$SDD_MTI(MODULE_UNIT_REF, parent_ivid)
/
create index IND_FK_MTI_TO_SQS on i$SDD_MTI(SQL_QUERY_SET_REF, parent_ivid)
/
create index IND_FK_MTI_TO_TAB on i$SDD_MTI(TABLE_REF)
/
create index PK_SDD_MTI_idx on i$SDD_MTI(IRID)
/
create index IND_FK_MUN_TO_GEM on i$SDD_MUN(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_MUN_TO_LAN on i$SDD_MUN(LANGUAGE_REF)
/
create index IND_FK_MUN_TO_MCO on i$SDD_MUN(MODULE_COMPONENT_REF, parent_ivid)
/
create index IND_NAME_MUN on i$SDD_MUN(NAME)
/
create index PK_SDD_MUN_idx on i$SDD_MUN(IRID)
/
create index IND_FK_MWF_TO_LAN on i$SDD_MWF(LANGUAGE_REF, parent_ivid)
/
create index PK_SDD_MWF_idx on i$SDD_MWF(IRID)
/
create index IND_NAME_OCL on i$SDD_OCL(NAME)
/
create index PK_SDD_OCL_idx on i$SDD_OCL(IRID)
/
create index IND_FK_OCO_TO_PCO on i$SDD_OCO(PRIMARY_KEY_REF)
/
create index IND_FK_OCO_TO_RELEND on i$SDD_OCO(RELATIONSHIP_END_REF)
/
create index IND_FK_OCO_TO_TAB on i$SDD_OCO(TABLE_REF, parent_ivid)
/
create index IND_FK_OCO_TO_TAB2 on i$SDD_OCO(FOREIGN_TABLE_REF)
/
create index IND_FK_OCO_TO_UCO on i$SDD_OCO(UNIQUE_KEY_REF)
/
create index IND_FK_OCO_TO_UID on i$SDD_OCO(UNIQUE_IDENTIFIER_REF)
/
create index IND_NAME_OCO on i$SDD_OCO(NAME)
/
create index PK_SDD_OCO_idx on i$SDD_OCO(IRID)
/
create index IND_FK_ODB_TO_E20 on i$SDD_ODB(NODE_REF)
/
create index IND_NAME_ODB on i$SDD_ODB(NAME)
/
create index PK_SDD_ODB_idx on i$SDD_ODB(IRID)
/
create index IND_FK_ODBODB_TO_ORC on i$SDD_ODBODB(DATABASE_REF_FROM, parent_ivid)
/
create index IND_FK_ODBODB_TO_ORC2 on i$SDD_ODBODB(DATABASE_REF_TO)
/
create index PK_SDD_ODBODB_idx on i$SDD_ODBODB(IRID)
/
create index IND_FK_OKY_TO_COL on i$SDD_OKY(COLUMN_REF)
/
create index IND_FK_OKY_TO_COL2 on i$SDD_OKY(FOREIGN_COLUMN_REF)
/
create index IND_FK_OKY_TO_COL3 on i$SDD_OKY(FOREIGN_COLUMN_REF2)
/
create index IND_FK_OKY_TO_CQA on i$SDD_OKY(CQA_REF)
/
create index IND_FK_OKY_TO_CQA2 on i$SDD_OKY(FOREIGN_CQA_REF)
/
create index IND_FK_OKY_TO_CQA3 on i$SDD_OKY(FOREIGN_CQA_REF2)
/
create index IND_FK_OKY_TO_OCO on i$SDD_OKY(CONSTRAINT_REF, parent_ivid)
/
create index PK_SDD_OKY_idx on i$SDD_OKY(IRID)
/
create index IND_FK_ORG_TO_FILES on i$SDD_ORG(ICON_FILE_REF)
/
create index IND_FK_ORG_TO_ORG on i$SDD_ORG(ORGANIZATION_UNIT_REF)
/
create index IND_NAME_ORG on i$SDD_ORG(NAME)
/
create index PK_SDD_ORG_idx on i$SDD_ORG(IRID)
/
create index IND_FK_ORGPER_TO_ORG on i$SDD_ORGPER(ORGANIZATION_UNIT_REF, parent_ivid)
/
create index IND_FK_ORGPER_TO_PER on i$SDD_ORGPER(PERSON_REF)
/
create index PK_SDD_ORGPER_idx on i$SDD_ORGPER(IRID)
/
create index IND_FK_ORS_TO_ORC on i$SDD_ORS(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_FK_ORS_TO_OSP on i$SDD_ORS(STORAGE_DEFINITION_REF)
/
create index IND_FK_ORS_TO_OTB on i$SDD_ORS(TABLESPACE_REF)
/
create index PK_SDD_ORS_idx on i$SDD_ORS(IRID)
/
create index IND_FK_ORT_TO_OOT on i$SDD_ORT(ORACLE_OBJECT_TYPE_REF)
/
create index IND_NAME_ORT on i$SDD_ORT(NAME)
/
create index PK_SDD_ORT_idx on i$SDD_ORT(IRID)
/
create index IND_NAME_OSP on i$SDD_OSP(NAME)
/
create index PK_SDD_OSP_idx on i$SDD_OSP(IRID)
/
create index IND_NAME_OSQ on i$SDD_OSQ(NAME)
/
create index PK_SDD_OSQ_idx on i$SDD_OSQ(IRID)
/
create index IND_FK_OST_TO_BOB on i$SDD_OST(BUSINESS_OBJECT_REF, parent_ivid)
/
create index IND_FK_OST_TO_CLA on i$SDD_OST(CLASSIFIER_REF, parent_ivid)
/
create index IND_FK_OST_TO_FILES on i$SDD_OST(ICON_FILE_REF)
/
create index IND_FK_OST_TO_WIT on i$SDD_OST(WORKFLOW_ITEM_TYPE_REF, parent_ivid)
/
create index IND_FK_OST_TO_WMT on i$SDD_OST(WORKFLOW_MESS_TYPE_REF, parent_ivid)
/
create index PK_SDD_OST_idx on i$SDD_OST(IRID)
/
create index IND_FK_OSTOST_TO_OST on i$SDD_OSTOST(OBJECT_STATE_ON_REF, parent_ivid)
/
create index IND_FK_OSTOST_TO_OST2 on i$SDD_OSTOST(OBJECT_STATE_OF_REF)
/
create index PK_SDD_OSTOST_idx on i$SDD_OSTOST(IRID)
/
create index IND_FK_OTB_TO_ODB on i$SDD_OTB(DATABASE_REF, parent_ivid)
/
create index IND_FK_OTB_TO_OSP on i$SDD_OTB(STORAGE_DEFINITION_REF)
/
create index PK_SDD_OTB_idx on i$SDD_OTB(IRID)
/
create index IND_NAME_PER on i$SDD_PER(NAME)
/
create index PK_SDD_PER_idx on i$SDD_PER(IRID)
/
create index IND_FK_PERACR_TO_ACR on i$SDD_PERACR(ACTOR_REF)
/
create index IND_FK_PERACR_TO_PER on i$SDD_PERACR(PERSON_REF, parent_ivid)
/
create index PK_SDD_PERACR_idx on i$SDD_PERACR(IRID)
/
create index IND_FK_PERPER_TO_PER on i$SDD_PERPER(MANAGER_REF, parent_ivid)
/
create index IND_FK_PERPER_TO_PER2 on i$SDD_PERPER(MANAGED_PERSON_REF)
/
create index PK_SDD_PERPER_idx on i$SDD_PERPER(IRID)
/
create index IND_FK_PGD_TO_COL on i$SDD_PGD(COLUMN_REF)
/
create index IND_FK_PGD_TO_DAT on i$SDD_PGD(DATASTRUCTURE_REF)
/
create index IND_FK_PGD_TO_DOM on i$SDD_PGD(DOMAIN_REF)
/
create index IND_FK_PGD_TO_GEM on i$SDD_PGD(GENERAL_MODULE_REF, parent_ivid)
/
create index IND_FK_PGD_TO_ORT on i$SDD_PGD(ORACLE_TYPE_REF)
/
create index IND_FK_PGD_TO_PLM on i$SDD_PGD(PLSQL_MODULE_REF, parent_ivid)
/
create index IND_FK_PGD_TO_TBL on i$SDD_PGD(TABLE_DEFINITION_REF)
/
create index PK_SDD_PGD_idx on i$SDD_PGD(IRID)
/
create index IND_NAME_PRS on i$SDD_PRS(NAME)
/
create index PK_SDD_PRS_idx on i$SDD_PRS(IRID)
/
create index IND_FK_PRU_TO_PRS on i$SDD_PRU(PREFERENCE_SET_REF)
/
create index PK_SDD_PRU_idx on i$SDD_PRU(IRID)
/
create index UK_PRU_idx on i$SDD_PRU(PREFERENCE_SET_REF,CIELEMENT_REF)
/
create index IND_FK_PSE_TO_RUL on i$SDD_PSE(NAMED_RULE_REF)
/
create index IND_NAME_PSE on i$SDD_PSE(TYPE)
/
create index PK_SDD_PSE_idx on i$SDD_PSE(IRID)
/
create index IND_NAME_PST on i$SDD_PST(NAME)
/
create index PK_SDD_PST_idx on i$SDD_PST(IRID)
/
create index IND_FK_PSTADC_TO_ADC on i$SDD_PSTADC(ATTRIBUTE_DOMAIN_REF)
/
create index IND_FK_PSTADC_TO_PST on i$SDD_PSTADC(PROJECT_STANDARD_REF, parent_ivid)
/
create index PK_SDD_PSTADC_idx on i$SDD_PSTADC(IRID)
/
create index IND_FK_PVL_TO_ARG on i$SDD_PVL(MODULE_ARGUMENT_REF)
/
create index IND_FK_PVL_TO_ARG2 on i$SDD_PVL(CALLED_ARGUMENT_REF)
/
create index IND_FK_PVL_TO_ITE on i$SDD_PVL(ITEM_REF)
/
create index IND_FK_PVL_TO_MODMOD on i$SDD_PVL(MODULE_NETWORK_REF, parent_ivid)
/
create index PK_SDD_PVL_idx on i$SDD_PVL(IRID)
/
create index IND_FK_QSU_TO_QUI on i$SDD_QSU(QUEUE_IMPLEMENTATION_REF, parent_ivid)
/
create index IND_NAME_QSU on i$SDD_QSU(NAME)
/
create index PK_SDD_QSU_idx on i$SDD_QSU(IRID)
/
create index IND_FK_QTD_TO_ORT on i$SDD_QTD(ORACLE_TYPE_REF)
/
create index IND_NAME_QTD on i$SDD_QTD(NAME)
/
create index PK_SDD_QTD_idx on i$SDD_QTD(IRID)
/
create index IND_FK_QUE_TO_QTD on i$SDD_QUE(QUEUE_TABLE_DEF_REF)
/
create index IND_NAME_QUE on i$SDD_QUE(NAME)
/
create index PK_SDD_QUE_idx on i$SDD_QUE(IRID)
/
create index IND_FK_QUI_TO_DBU on i$SDD_QUI(QUEUE_TABLE_DBU_REF)
/
create index IND_FK_QUI_TO_NPQ on i$SDD_QUI(NON_PERSISTENT_QUEUE_REF)
/
create index IND_FK_QUI_TO_ORC on i$SDD_QUI(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_FK_QUI_TO_PQU on i$SDD_QUI(PERSISTENT_QUEUE_REF)
/
create index PK_SDD_QUI_idx on i$SDD_QUI(IRID)
/
create index IND_FK_RELEND_TO_ENT on i$SDD_RELEND(FROM_ENTITY_REF, parent_ivid)
/
create index IND_FK_RELEND_TO_ENT2 on i$SDD_RELEND(TO_ENTITY_REF)
/
create index IND_FK_RELEND_TO_RELEND on i$SDD_RELEND(OTHER_RELATIONSHIP_END_REF)
/
create index IND_NAME_RELEND on i$SDD_RELEND(NAME)
/
create index PK_SDD_RELEND_idx on i$SDD_RELEND(IRID)
/
create index IND_FK_RGP_TO_ORC on i$SDD_RGP(ORACLE_DATABASE_REF)
/
create index IND_FK_RGP_TO_RPG on i$SDD_RGP(REPLICATION_GROUP_REF, parent_ivid)
/
create index PK_SDD_RGP_idx on i$SDD_RGP(IRID)
/
create index IND_FK_RPG_TO_ORC on i$SDD_RPG(ORACLE_DATABASE_REF, parent_ivid)
/
create index PK_SDD_RPG_idx on i$SDD_RPG(IRID)
/
create index IND_FK_RUL_TO_EVC on i$SDD_RUL(EVENT_CLASSIFIER_REF)
/
create index IND_FK_RUL_TO_LAN on i$SDD_RUL(LANGUAGE_REF)
/
create index IND_FK_RUL_TO_MET on i$SDD_RUL(METHOD_REF)
/
create index IND_NAME_RUL on i$SDD_RUL(NAME)
/
create index PK_SDD_RUL_idx on i$SDD_RUL(IRID)
/
create index IND_FK_RULRUL_TO_RUL on i$SDD_RULRUL(USED_IN_RULE_REF, parent_ivid)
/
create index IND_FK_RULRUL_TO_RUL2 on i$SDD_RULRUL(USE_OF_RULE_REF)
/
create index PK_SDD_RULRUL_idx on i$SDD_RULRUL(IRID)
/
create index IND_FK_SBA_TO_EVS on i$SDD_SBA(EVENT_SUBSCRIPTION_REF)
/
create index IND_FK_SBA_TO_MET on i$SDD_SBA(METHOD_REF, parent_ivid)
/
create index IND_FK_SBA_TO_SUD on i$SDD_SBA(SUBSCRIPTION_DETAIL_REF)
/
create index PK_SDD_SBA_idx on i$SDD_SBA(IRID)
/
create index IND_FK_SMI_TO_UDS on i$SDD_SMI(USER_DEFINED_SET_REF, parent_ivid)
/
create index PK_SDD_SMI_idx on i$SDD_SMI(IRID)
/
create index IND_FK_SOU_TO_BLI on i$SDD_SOU(BATCHLINE_REF, parent_ivid)
/
create index PK_SDD_SOU_idx on i$SDD_SOU(IRID)
/
create index IND_FK_SPV_TO_DBU on i$SDD_SPV(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_SPV_TO_GRP on i$SDD_SPV(ROLE_REF, parent_ivid)
/
create index PK_SDD_SPV_idx on i$SDD_SPV(IRID)
/
create index IND_FK_SQS_TO_LOV on i$SDD_SQS(LIST_OF_VALUES_REF, parent_ivid)
/
create index IND_FK_SQS_TO_MCO on i$SDD_SQS(MODULE_COMPONENT_REF, parent_ivid)
/
create index PK_SDD_SQS_idx on i$SDD_SQS(IRID)
/
create index IND_FK_SRG_TO_ORC on i$SDD_SRG(ORACLE_DATABASE_REF, parent_ivid)
/
create index IND_FK_SRG_TO_ORS on i$SDD_SRG(ROLLBACK_SEGMENT_REF)
/
create index PK_SDD_SRG_idx on i$SDD_SRG(IRID)
/
create index IND_FK_SRU_TO_LAN on i$SDD_SRU(LANGUAGE_REF)
/
create index IND_FK_SRU_TO_MET on i$SDD_SRU(METHOD_REF)
/
create index IND_FK_SRU_TO_OST on i$SDD_SRU(OBJECT_STATE_REF, parent_ivid)
/
create index PK_SDD_SRU_idx on i$SDD_SRU(IRID)
/
create index IND_FK_STE_TO_FILES on i$SDD_STE(ICON_FILE_REF)
/
create index IND_NAME_STE on i$SDD_STE(NAME)
/
create index PK_SDD_STE_idx on i$SDD_STE(IRID)
/
create index IND_FK_STESTE_TO_STE on i$SDD_STESTE(SUBTYPE_REF, parent_ivid)
/
create index IND_FK_STESTE_TO_STE2 on i$SDD_STESTE(SUPERTYPE_REF)
/
create index PK_SDD_STESTE_idx on i$SDD_STESTE(IRID)
/
create index IND_FK_SUD_TO_AEN on i$SDD_SUD(ASSOCIATION_END_REF)
/
create index IND_FK_SUD_TO_CLAEVC on i$SDD_SUD(EVENT_PUBLICATION_REF)
/
create index IND_FK_SUD_TO_EVS on i$SDD_SUD(EVENT_SUBSCRIPTION_REF, parent_ivid)
/
create index PK_SDD_SUD_idx on i$SDD_SUD(IRID)
/
create index IND_FK_SYN_TO_ENT on i$SDD_SYN(ENTITY_REF)
/
create index IND_FK_SYN_TO_TER on i$SDD_SYN(TERM_REF)
/
create index IND_NAME_SYN on i$SDD_SYN(NAME)
/
create index PK_SDD_SYN_idx on i$SDD_SYN(IRID)
/
create index IND_FK_TAB_RFI on i$SDD_TAB(RECORD_FILE_REF)
/
create index IND_FK_TAB_TO_OCL on i$SDD_TAB(CLUSTER_REF)
/
create index IND_FK_TAB_TO_OOT on i$SDD_TAB(ORACLE_OBJECT_TYPE_REF)
/
create index IND_NAME_TAB on i$SDD_TAB(NAME)
/
create index IND_SHORT_NAME_TAB on i$SDD_TAB(ALIAS)
/
create index PK_SDD_TAB_idx on i$SDD_TAB(IRID)
/
create index IND_FK_TABENT_TO_COL on i$SDD_TABENT(COLUMN_REF)
/
create index IND_FK_TABENT_TO_ENT on i$SDD_TABENT(ENTITY_REF)
/
create index IND_FK_TABENT_TO_TAB on i$SDD_TABENT(TABLE_REF, parent_ivid)
/
create index PK_SDD_TABENT_idx on i$SDD_TABENT(IRID)
/
create index IND_FK_TAG_TO_STE on i$SDD_TAG(STEREOTYPE_REF, parent_ivid)
/
create index PK_SDD_TAG_idx on i$SDD_TAG(IRID)
/
create index IND_FK_TAGVAL_TO_TAG on i$SDD_TAGVAL(TAG_REF)
/
create index PK_SDD_TAGVAL_idx on i$SDD_TAGVAL(IRID)
/
create index UK_TAGVAL_idx on i$SDD_TAGVAL(ELEMENT_REF,TAG_REF)
/
create index IND_FK_TBICOL_TO_COL on i$SDD_TBICOL(COLUMN_REF)
/
create index IND_FK_TBICOL_TO_INS on i$SDD_TBICOL(INDEX_STORAGE_REF, parent_ivid)
/
create index IND_FK_TBICOL_TO_TBI on i$SDD_TBICOL(TABLE_IMPLEMENTATION_REF, parent_ivid)
/
create index PK_SDD_TBICOL_idx on i$SDD_TBICOL(IRID)
/
create index IND_FK_TBP_TO_OSP on i$SDD_TBP(STORAGE_DEFINITION_REF)
/
create index IND_FK_TBP_TO_OTB on i$SDD_TBP(TABLESPACE_REF)
/
create index IND_FK_TBP_TO_TBI on i$SDD_TBP(TABLE_IMPLEMENTATION_REF, parent_ivid)
/
create index PK_SDD_TBP_idx on i$SDD_TBP(IRID)
/
create index IND_NAME_TER on i$SDD_TER(NAME)
/
create index PK_SDD_TER_idx on i$SDD_TER(IRID)
/
create index IND_NAME_TMS on i$SDD_TMS(TRANSFORMATION_TYPE)
/
create index PK_SDD_TMS_idx on i$SDD_TMS(IRID)
/
create index IND_FK_TRA_TO_ACT on i$SDD_TRA(SOURCE_ACTIVITY_REF, parent_ivid)
/
create index IND_FK_TRA_TO_ACT2 on i$SDD_TRA(TARGET_ACTIVITY_REF)
/
create index IND_FK_TRA_TO_ACTORG on i$SDD_TRA(SOURCE_ACT_USAGE_REF, parent_ivid)
/
create index IND_FK_TRA_TO_ACTORG2 on i$SDD_TRA(TARGET_ACT_USAGE_REF)
/
create index IND_FK_TRA_TO_CLAEVC on i$SDD_TRA(EVENT_PUBLICATION_REF)
/
create index IND_FK_TRA_TO_EVC on i$SDD_TRA(SOURCE_EVENT_REF, parent_ivid)
/
create index IND_FK_TRA_TO_EVC2 on i$SDD_TRA(TARGET_EVENT_REF)
/
create index IND_FK_TRA_TO_EVC3 on i$SDD_TRA(TRIGGER_EVENT_REF)
/
create index IND_FK_TRA_TO_EVS on i$SDD_TRA(EVENT_SUBSCRIPTION_REF)
/
create index IND_FK_TRA_TO_OST on i$SDD_TRA(SOURCE_OBJECT_STATE_REF, parent_ivid)
/
create index IND_FK_TRA_TO_OST2 on i$SDD_TRA(TARGET_OBJECT_STATE_REF)
/
create index IND_FK_TRA_TO_PSE on i$SDD_TRA(SOURCE_PSEUDOSTATE_REF, parent_ivid)
/
create index IND_FK_TRA_TO_PSE2 on i$SDD_TRA(TARGET_PSEUDOSTATE_REF)
/
create index IND_FK_TRA_TO_RUL on i$SDD_TRA(NAMED_RULE_REF)
/
create index IND_FK_TRA_TO_TRA on i$SDD_TRA(TRANSITION_REF)
/
create index PK_SDD_TRA_idx on i$SDD_TRA(IRID)
/
create index IND_FK_TRG_TO_PLM on i$SDD_TRG(PLSQL_MODULE_REF)
/
create index IND_FK_TRG_TO_TBL on i$SDD_TRG(TABLE_DEFINITION_REF, parent_ivid)
/
create index IND_FK_TRG_TO_VW on i$SDD_TRG(VIEW_DEFINITION_REF, parent_ivid)
/
create index IND_NAME_TRG on i$SDD_TRG(NAME)
/
create index PK_SDD_TRG_idx on i$SDD_TRG(IRID)
/
create index IND_FK_TRGCOL_TO_COL on i$SDD_TRGCOL(COLUMN_REF)
/
create index IND_FK_TRGCOL_TO_TRG on i$SDD_TRGCOL(DATABASE_TRIGGER_REF, parent_ivid)
/
create index PK_SDD_TRGCOL_idx on i$SDD_TRGCOL(IRID)
/
create index IND_FK_TSQ_TO_DBU on i$SDD_TSQ(DATABASE_USER_REF, parent_ivid)
/
create index IND_FK_TSQ_TO_OTB on i$SDD_TSQ(TABLESPACE_REF)
/
create index PK_SDD_TSQ_idx on i$SDD_TSQ(IRID)
/
create index IND_FK_UCA_TO_GEA on i$SDD_UCA(GENERAL_ACTION_REF)
/
create index IND_FK_UCA_TO_USC on i$SDD_UCA(USE_CASE_REF, parent_ivid)
/
create index IND_FK_UCA_TO_USC2 on i$SDD_UCA(USE_CASE_INVOKED_REF)
/
create index IND_FK_UCA_TO_USCEVO on i$SDD_UCA(USE_CASE_EVENT_OUT_REF)
/
create index IND_NAME_UCA on i$SDD_UCA(NAME)
/
create index PK_SDD_UCA_idx on i$SDD_UCA(IRID)
/
create index IND_NAME_UDE on i$SDD_UDE(NAME)
/
create index PK_SDD_UDE_idx on i$SDD_UDE(IRID)
/
create index IND_FK_UDECLI_TO_UDE on i$SDD_UDECLI(UML_DEPENDENCY_REF, parent_ivid)
/
create index PK_SDD_UDECLI_idx on i$SDD_UDECLI(IRID)
/
create index IND_FK_UDESUP_TO_UDE on i$SDD_UDESUP(UML_DEPENDENCY_REF, parent_ivid)
/
create index PK_SDD_UDESUP_idx on i$SDD_UDESUP(IRID)
/
create index IND_NAME_UDS on i$SDD_UDS(NAME)
/
create index PK_SDD_UDS_idx on i$SDD_UDS(IRID)
/
create index IND_NAME_UEE on i$SDD_UEE(NAME)
/
create index PK_SDD_UEE_idx on i$SDD_UEE(IRID)
/
create index PK_SDD_UES_idx on i$SDD_UES(IRID)
/
create index UK_UES_idx on i$SDD_UES(PART_OF_REF,USE_OF_REF,ELEMENT_TYPE_NAME)
/
create index IND_FK_UID_TO_ENT on i$SDD_UID(ENTITY_REF, parent_ivid)
/
create index PK_SDD_UID_idx on i$SDD_UID(IRID)
/
create index PK_SDD_UPR_idx on i$SDD_UPR(IRID)
/
create index UK_UPR_idx on i$SDD_UPR(CIELEMENT_REF,PRODUCT_FLAVOR,PREFERENCE_NAME)
/
create index IND_NAME_URU on i$SDD_URU(NAME)
/
create index PK_SDD_URU_idx on i$SDD_URU(IRID)
/
create index IND_FK_USC_TO_FILES on i$SDD_USC(ICON_FILE_REF)
/
create index IND_FK_USC_TO_RUL on i$SDD_USC(PRE_RULE_REF)
/
create index IND_FK_USC_TO_RUL2 on i$SDD_USC(POST_RULE_REF)
/
create index IND_NAME_USC on i$SDD_USC(NAME)
/
create index PK_SDD_USC_idx on i$SDD_USC(IRID)
/
create index IND_FK_USCACR_TO_ACR on i$SDD_USCACR(ACTOR_REF)
/
create index IND_FK_USCACR_TO_USC on i$SDD_USCACR(USE_CASE_REF, parent_ivid)
/
create index PK_SDD_USCACR_idx on i$SDD_USCACR(IRID)
/
create index IND_FK_USCE1_TO_E1 on i$SDD_USCE1(OBJECTIVE_REF)
/
create index IND_FK_USCE1_TO_USC on i$SDD_USCE1(USE_CASE_REF, parent_ivid)
/
create index PK_SDD_USCE1_idx on i$SDD_USCE1(IRID)
/
create index IND_FK_USCEPA_TO_EPA on i$SDD_USCEPA(EXTENSION_POINT_REF)
/
create index IND_FK_USCEPA_TO_RUL on i$SDD_USCEPA(NAMED_RULE_REF)
/
create index IND_FK_USCEPA_TO_USC on i$SDD_USCEPA(USE_CASE_REF, parent_ivid)
/
create index IND_FK_USCEPA_TO_USC2 on i$SDD_USCEPA(USE_CASE_FROM_REF)
/
create index PK_SDD_USCEPA_idx on i$SDD_USCEPA(IRID)
/
create index IND_FK_USCEVI_TO_EVC on i$SDD_USCEVI(EVENT_CLASSIFIER_REF)
/
create index IND_FK_USCEVI_TO_USC on i$SDD_USCEVI(USE_CASE_REF, parent_ivid)
/
create index PK_SDD_USCEVI_idx on i$SDD_USCEVI(IRID)
/
create index IND_FK_USCEVO_TO_EVC on i$SDD_USCEVO(EVENT_CLASSIFIER_REF)
/
create index IND_FK_USCEVO_TO_USC on i$SDD_USCEVO(USE_CASE_REF, parent_ivid)
/
create index PK_SDD_USCEVO_idx on i$SDD_USCEVO(IRID)
/
create index IND_FK_USCUSC_TO_USC on i$SDD_USCUSC(SUBTYPE_REF, parent_ivid)
/
create index IND_FK_USCUSC_TO_USC2 on i$SDD_USCUSC(SUPERTYPE_REF)
/
create index PK_SDD_USCUSC_idx on i$SDD_USCUSC(IRID)
/
create index UK_USCUSC_2_idx on i$SDD_USCUSC(SUPERTYPE_REF,SEQUENCE)
/
create index IND_FK_VAL_TO_ADC on i$SDD_VAL(ATTRIBUTE_DOMAIN_REF, parent_ivid)
/
create index IND_FK_VAL_TO_GEC on i$SDD_VAL(GENERIC_CLASS_REF)
/
create index IND_FK_VAL_TO_INR on i$SDD_VAL(INTEGRITY_RULE_REF, parent_ivid)
/
create index PK_SDD_VAL_idx on i$SDD_VAL(IRID)
/
create index IND_FK_VALGAT_TO_GAT on i$SDD_VALGAT(GENERAL_ATTRIBUTE_REF)
/
create index IND_FK_VALGAT_TO_VAL on i$SDD_VALGAT(VALIDATOR_REF, parent_ivid)
/
create index PK_SDD_VALGAT_idx on i$SDD_VALGAT(IRID)
/
create index IND_FK_VLE_TO_AEU on i$SDD_VLE(ASSOC_END_USAGE_REF)
/
create index IND_FK_VLE_TO_VLI on i$SDD_VLE(VIEW_LINK_REF, parent_ivid)
/
create index IND_FK_VLE_TO_VOB on i$SDD_VLE(VIEW_OBJECT_REF)
/
create index PK_SDD_VLE_idx on i$SDD_VLE(IRID)
/
create index IND_FK_VLEU_TO_VLE on i$SDD_VLEU(VIEW_LINK_END_REF)
/
create index IND_FK_VLEU_TO_VLU on i$SDD_VLEU(VIEW_LINK_USAGE_REF, parent_ivid)
/
create index IND_FK_VLEU_TO_VOU on i$SDD_VLEU(VIEW_USAGE_REF)
/
create index PK_SDD_VLEU_idx on i$SDD_VLEU(IRID)
/
create index IND_FK_VLEVOA_TO_VLE on i$SDD_VLEVOA(VIEW_LINK_END_REF, parent_ivid)
/
create index IND_FK_VLEVOA_TO_VOA on i$SDD_VLEVOA(VIEW_OBJECT_ATT_REF)
/
create index PK_SDD_VLEVOA_idx on i$SDD_VLEVOA(IRID)
/
create index IND_NAME_VLI on i$SDD_VLI(NAME)
/
create index PK_SDD_VLI_idx on i$SDD_VLI(IRID)
/
create index IND_FK_VLU_TO_AMC on i$SDD_VLU(APPLICATION_MODULE_REF, parent_ivid)
/
create index IND_FK_VLU_TO_VLI on i$SDD_VLU(VIEW_LINK_REF)
/
create index PK_SDD_VLU_idx on i$SDD_VLU(IRID)
/
create index IND_FK_VOU_TO_AMC on i$SDD_VOU(APPLICATION_MODULE_REF, parent_ivid)
/
create index IND_FK_VOU_TO_VOB on i$SDD_VOU(VIEW_OBJECT_REF)
/
create index PK_SDD_VOU_idx on i$SDD_VOU(IRID)
/
create index IND_FK_VWTAB_TO_TAB on i$SDD_VWTAB(VIEW_REF, parent_ivid)
/
create index IND_FK_VWTAB_TO_TAB2 on i$SDD_VWTAB(TABLE_REF)
/
create index PK_SDD_VWTAB_idx on i$SDD_VWTAB(IRID)
/
create index IND_FK_WAT_TO_ADC on i$SDD_WAT(ATTRIBUTE_DOMAIN_REF)
/
create index IND_FK_WAT_TO_CAT on i$SDD_WAT(CLASSIFIER_ATTRIBUTE_REF)
/
create index IND_FK_WAT_TO_WIT on i$SDD_WAT(WORKFLOW_ITEM_TYPE_REF, parent_ivid)
/
create index IND_FK_WAT_TO_WMT on i$SDD_WAT(WORKFLOW_MESS_TYPE_REF, parent_ivid)
/
create index PK_SDD_WAT_idx on i$SDD_WAT(IRID)
/
create index IND_FK_WIN_TO_GEM on i$SDD_WIN(GENERAL_MODULE_REF, parent_ivid)
/
create index PK_SDD_WIN_idx on i$SDD_WIN(IRID)
/
create index IND_NAME_WIT on i$SDD_WIT(NAME)
/
create index PK_SDD_WIT_idx on i$SDD_WIT(IRID)
/
create index IND_FK_WMT_TO_WIT on i$SDD_WMT(WORKFLOW_ITEM_TYPE_REF, parent_ivid)
/
create index PK_SDD_WMT_idx on i$SDD_WMT(IRID)
/

-- CW 7-Dec-99
-- Add new indexes from patch ci04012.091

create index IND_DEU_REF_TO_ELMT            on I$SDD_DEU      ( CIELEMENT_REF         )
/
create index IND_DOCXXX_REF_TO_ACE          on I$SDD_DOCXXX   ( ELEMENT_REF           )
/
create index IND_ERU_REF_TO_ELMT            on I$SDD_ERU      ( CIELEMENT_REF         )
/
create index IND_MAP_REF_TO_ELMT            on I$SDD_MAP      ( SOURCE_CIELEMENT_REF  )
/
create index IND_MAP_REF_TO_ELMT2           on I$SDD_MAP      ( TARGET_CIELEMENT_REF  )
/
create index IND_PRU_REF_TO_ELMT            on I$SDD_PRU      ( CIELEMENT_REF         )
/
create index IND_SMI_REF_TO_PAC             on I$SDD_SMI      ( ELEMENT_REF           )
/
create index IND_SOU_REF_TO_ELMT            on I$SDD_SOU      ( CIELEMENT_REF         )
/
create index IND_TAGVAL_REF_TO_ELMT         on I$SDD_TAGVAL   ( ELEMENT_REF           )
/
create index IND_UDECLI_REF_TO_ELMT         on I$SDD_UDECLI   ( CLIENT_ELEMENT_REF    )
/
create index IND_UDESUP_REF_TO_ELMT         on I$SDD_UDESUP   ( SUPPLIER_ELEMENT_REF  )
/
create index IND_UES_REF_TO_ACE             on I$SDD_UES      ( PART_OF_REF           )
/
create index IND_UES_REF_TO_ACE2            on I$SDD_UES      ( USE_OF_REF            )
/
create index IND_UPR_REF_TO_ELMT            on I$SDD_UPR      ( CIELEMENT_REF         )
/

-- CW 21-Mar-2000
-- Fix (patch) bug 1239279, add missing indexes

create index RM_TEXT_LINES_IDX on i$RM_TEXT_LINES(IRID)
/
create index CK_APPLICATION_LOGIC_IDX on i$CK_APPLICATION_LOGIC(IRID)
/

