Foreign Constraints and Columns Without an Index on Child Table
Notes SQL Source Snapshot Date: 10/28/02 00:32:59 Database: VENUS
Owner Constraint Name Column/Position Problem
HRCOUNTR_REG_FKREGION_ID[1]No Index
HRDEPT_MGR_FKMANAGER_ID[1]No Index
MDSYSFK_SRIDSRID[1]No Index
ODMLIFT_RESULT_ENTRY_FKLIFT_RESULT_ID[1]No Index
ODMLIFT_RESULT_FKLIFT_RESULT_NAME[1]No Index
ODMMINING_TASK_STATE_FKID[1]No Index
ODMMS_RESULT_FKMODEL_SEEKER_RESULT_ID[1]No Index
ODMTEST_RESULT_FKTEST_RESULT_NAME[1]No Index
OEMREPEPC_CLI_COLLECTION_C3ENVIRONMENT_ID[2]No Index
OEMREPEPC_CLI_COLLECT_BY_EVENTID_C0REP_USER_ID[1]No Index
OEMREPEPC_CLI_COLLECT_BY_EVENTID_C1COLLECTION_ID[2]No Index
OEMREPEPC_CLI_COLLECT_BY_EVENTID_C1REP_USER_ID[1]No Index
OEMREPEPC_CLI_COLLECT_BY_USERID_C0REP_USER_ID[1]No Index
OEMREPEPC_CLI_COLLECT_BY_USERID_C1COLLECTION_ID[2]No Index
OEMREPEPC_CLI_COLLECT_BY_USERID_C1REP_USER_ID[1]No Index
OEMREPEPC_CLI_ENVIRONMENT_VERSION_C0REP_USER_ID[1]No Index
OEMREPEPC_CLI_ENVIRONMENT_VERSION_C1ENVIRONMENT_ID[2]No Index
OEMREPEPC_CLI_ENVIRONMENT_VERSION_C1REP_USER_ID[1]No Index
OEMREPEPC_CLI_ENVIRONTMENT_C2NODE_ID[2]No Index
OEMREPEPC_CLI_FORMAT_C2COLLECTION_ID[2]No Index
OEMREPEPC_CLI_PROGRESS_C2COLLECTION_ID[2]No Index
OEMREPEPC_CLI_SERVICE_C3ENVIRONMENT_ID[2]No Index
OEMREPEPC_CLI_USAGE_C0REP_USER_ID[1]No Index
OEMREPEPC_CLI_USAGE_C1COLLECTION_ID[2]No Index
OEMREPEPC_CLI_USAGE_C1REP_USER_ID[1]No Index
OEMREPEPC_VIEW_IDEPC_VIEW_ID[1]No Index
OEMREPEXUPD_CP_FKCP_ID[1]No Index
OEMREPFK_DISPLAYDISPLAY_ID[1]No Index
OEMREPFK_SMP_VDN_TARGETLIST_IDTARGETID[1]No Index
OEMREPFK_VDE_THRESHOLD_PRINCIPALPRINCIPAL_ID[1]No Index
OEMREPMULTI_VIEW_ID_2MULTI_VIEW_ID[1]No Index
OEMREPMULTI_VIEW_ID_3MULTI_VIEW_ID[1]No Index
OEMREPSMP_LMV_DISPLAY_OPTION_IDSEARCH_ID[1]No Index
OEMREPSMP_LMV_REDO_LOG_IDSEARCH_ID[1]No Index
OEMREPSMP_LMV_SEARCH_RESULT_IDSEARCH_ID[1]No Index
OEMREPSYS_C002797EVENT_ID[1]No Index
OEMREPSYS_C002797TARGET_NAME[2]No Index
OEMREPSYS_C002797TARGET_TYPE[3]No Index
OEMREPSYS_C003110DATABASE_ID[1]No Index
OEMREPSYS_C003110SQLID[2]No Index
OEMREPSYS_C003111DATABASE_ID[1]No Index
OEMREPSYS_C003111SQLID[2]No Index
OEMREPSYS_C003112DATABASE_ID[1]No Index
OEMREPSYS_C003112SQLID[2]No Index
OEMREPSYS_C003113DATABASE_ID[1]No Index
OEMREPSYS_C003113SQLID[2]No Index
OEMREPSYS_C003114DATABASE_ID[1]No Index
OEMREPSYS_C003114SQLID[2]No Index
OEMREPSYS_C003115DATABASE_ID[1]No Index
OEMREPSYS_C003115SQLID[2]No Index
OEMREPSYS_C003116DATABASE_ID[1]No Index
OEMREPSYS_C003116SQLID[2]No Index
OEMREPSYS_C003117DATABASE_ID[1]No Index
OEMREPSYS_C003117SQLID[2]No Index
OEMREPSYS_C003118DATABASE_ID[1]No Index
OEMREPSYS_C003118SQLID[2]No Index
OEMREPSYS_C003119DATABASE_ID[1]No Index
OEMREPSYS_C003119SQLID[2]No Index
OEMREPSYS_C003120DATABASE_ID[1]No Index
OEMREPSYS_C003120SQLID[2]No Index
OEMREPVIEW_CAT_ID_2VIEW_CAT_ID[1]No Index
OEMREPVIEW_ID_2VIEW_ID[1]No Index
OLAPSYSCWM$ARGUMENT_FKPARAMETER_IRID[1]No Index
OLAPSYSCWM$CLASSIFICATIONENTRY_FKCLASSIFICATION_IRID[1]No Index
OLAPSYSCWM$CLASSIFICATIONTYPE_FKPROJECT_IRID[1]No Index
OLAPSYSCWM$CLASSIFICATION_FKPROJECT_IRID[1]No Index
OLAPSYSCWM$CUBE_FKDATAMODEL_IRID[1]No Index
OLAPSYSCWM$DIMENSIONATTRIBUTE_FKITEMCONTAINER_IRID[1]No Index
OLAPSYSCWM$DIMENSION_FKDATAMODEL_IRID[1]No Index
OLAPSYSCWM$DOMAIN_FKDEFINITIONMODEL_IRID[1]No Index
OLAPSYSCWM$FACTLEVELGROUP_FKFACTUSE_IRID[1]No Index
OLAPSYSCWM$FACTLEVELUSE_FKFACTLEVELGROUP_IRID[1]No Index
OLAPSYSCWM$FUNCTION_FKPROCESSMODEL_IRID[1]No Index
OLAPSYSCWM$HIERARCHY_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM$LEVEL_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM$MODEL_FKPROJECT_IRID[1]No Index
OLAPSYSCWM$MODEL_FK_1MODEL_IRID[1]No Index
OLAPSYSCWM$OBJECTTYPE_FKPROJECT_IRID[1]No Index
OLAPSYSCWM$OBJECTTYPE_FK_1CLASSIFICATIONTYPE_IRID[1]No Index
OLAPSYSCWM$PARAMETER_FKOPERATION_IRID[1]No Index
OLAPSYSCWM2$CUBEDIMENSIONUSE_CUBE_FKCUBE_IRID[1]No Index
OLAPSYSCWM2$CUBEDIMENSIONUSE_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$DIMATTR_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$DIMHIERLVLMAP_DHL_FKDIMHIERLVL_IRID[1]No Index
OLAPSYSCWM2$FACTDIMHIERMAP_CUBE_FKCUBE_IRID[1]No Index
OLAPSYSCWM2$FACTDIMHTD_CUBE_FKCUBE_IRID[1]No Index
OLAPSYSCWM2$FACTDIMHTD_FDHM_FKFACTDIMHIER_IRID[1]No Index
OLAPSYSCWM2$FACTKEYDHLM_FKDHM_FKFACTKEYDIMHIER_IRID[1]No Index
OLAPSYSCWM2$FACTKEYDHM_FDHM_FKFACTDIMHIER_IRID[1]No Index
OLAPSYSCWM2$HIERARCHY_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$HIERLEVELREL_CLEVEL_FKCHILDLEVEL_IRID[1]No Index
OLAPSYSCWM2$HIERLEVELREL_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$HIERLEVELREL_HIER_FKHIERARCHY_IRID[1]No Index
OLAPSYSCWM2$HIERLEVELREL_PLEVEL_FKPARENTLEVEL_IRID[1]No Index
OLAPSYSCWM2$LEVELATTR_DIMATTR_FKDIMATTR_IRID[1]No Index
OLAPSYSCWM2$LEVELATTR_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$LEVELATTR_LEVEL_FKLEVEL_IRID[1]No Index
OLAPSYSCWM2$LEVEL_DIM_FKDIMENSION_IRID[1]No Index
OLAPSYSCWM2$LOGICALATTRUSE_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$LOGICALDIMUSE_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$LOGICALHIERUSE_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$LOGICALLEVELUSE_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$LOGICALMEASUSE_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$LVLATTRMAP_HIERLVLREL_FKHIERLVLREL_IRID[1]No Index
OLAPSYSCWM2$LVLATTRMAP_LVLATTR_FKLEVELATTR_IRID[1]No Index
OLAPSYSCWM2$MEASURETABLEMAP_FDHM_FKFACTDIMHIER_IRID[1]No Index
OLAPSYSCWM2$MEASURETABLEMAP_MEAS_FKMEASURE_IRID[1]No Index
OLAPSYSCWM2$MEASURE_CUBE_FKCUBE_IRID[1]No Index
OLAPSYSCWM2$PHYSOBJEXT_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$PHYSOBJPROPS_OBJ_FKAW_OBJ_IRID[1]No Index
OLAPSYSCWM2$PHYSOBJRELOBJ_OBJ2_FKAW_RELATED_OBJ_IRID[1]No Index
OLAPSYSCWM2$PHYSOBJRELOBJ_OBJ_FKAW_OBJ_IRID[1]No Index
SHCUSTOMERS_COUNTRY_FKCOUNTRY_ID[1]No Index
SYSHS$_CLASS_CAPS_FK2CAP_NUMBER[1]No Index
SYSHS$_CLASS_DD_FK2DD_TABLE_ID[1]No Index
SYSHS$_FDS_INST_FK1FDS_CLASS_ID[1]No Index
SYSHS$_INST_CAPS_FK2CAP_NUMBER[1]No Index
SYSHS$_INST_DD_FK2DD_TABLE_ID[1]No Index
SYSREGISTRY_PARENT_FKPID[1]No Index
SYSTEMMVIEW$_ADV_AJG_FKRUNID#[1]No Index
SYSTEMMVIEW$_ADV_BASETABLE_FKQUERYID#[1]No Index
SYSTEMMVIEW$_ADV_CLIQUE_FKRUNID#[1]No Index
SYSTEMMVIEW$_ADV_ELIGIBLE_FKRUNID#[1]No Index
SYSTEMMVIEW$_ADV_EXCEPTION_FKRUNID#[1]No Index
SYSTEMMVIEW$_ADV_FILTERINSTANCE_FKRUNID#[1]No Index
SYSTEMMVIEW$_ADV_FJG_FKAJGID#[1]No Index
SYSTEMMVIEW$_ADV_GC_FKFJGID#[1]No Index
SYSTEMMVIEW$_ADV_ROLLUP_PFKPLEVELID#[2]No Index
SYSTEMREPCAT$_AUDIT_COLUMN_F1ATTRIBUTE[1]No Index
SYSTEMREPCAT$_AUDIT_COLUMN_F2BASE_CONFLICT_TYPE_ID[3]No Index
SYSTEMREPCAT$_AUDIT_COLUMN_F2BASE_ONAME[2]No Index
SYSTEMREPCAT$_AUDIT_COLUMN_F2BASE_REFERENCE_NAME[4]No Index
SYSTEMREPCAT$_AUDIT_COLUMN_F2BASE_SNAME[1]No Index
SYSTEMREPCAT$_REFRESH_TEMPLATES_FK1TEMPLATE_TYPE_ID[1]No Index
SYSTEMREPCAT$_REFRESH_TEMPLATES_FK2TEMPLATE_STATUS_ID[1]No Index
SYSTEMREPCAT$_SITE_OBJECTS_FK1OBJECT_TYPE_ID[1]No Index
SYSTEMREPCAT$_TEMPLATE_OBJECTS_FK3OBJECT_TYPE[1]No Index
WKSYSSYS_C001718WK$IID[1]No Index
WKSYSSYS_C001729DS_TYPE_ID[2]No Index
WKSYSSYS_C001747SG_ID[2]No Index
WKSYSSYS_C001761SM_SCHED_ID[2]No Index
WKSYSSYS_C001790AU_SEARCH_ATTR_ID[2]No Index
WKSYSSYS_C001803WK$IID[1]No Index
WKSYSSYS_C001804WK$IID[1]No Index
WKSYSSYS_C001805PV_DS_ID[2]No Index
WKSYSSYS_C001805WK$IID[1]No Index