Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

No indexes on columns involved in foreign key constraints

You should almost always index foreign keys. The only exception is when the matching unique or primary key is never updated or deleted. For more information take a look on Concurrency Control, Indexes, and Foreign Keys.
The sql file which will generate these indexes is here

"Unindexed" foreign keys

Constraint nameTable NameColumns
ADMINISTRATION_INFO SYS_C002087349 GROUP_ID
ADV_CATEGORIES SYS_C002087695 CATEGORY_ID
ADV_GROUP_MAP SYS_C002087704 ADV_KEY
ADV_USER_MAP SYS_C002087690 ADV_KEY
AD_DOMAINS SYS_C002087570 PRIMARY_MAINTAINER_ID
AD_INTEGRITY_CHECKS SYS_C002087572 DOMAIN_ID
AD_MONITORING_TOP_PROC AD_MNTR_TOP_PROC_TOP_ID TOP_ID
AD_PARAMETER_VALUES AD_PARAM_VALS_ELTS_ID_FK ELEMENT_ID
AD_PARTNER SYS_C002088091 GROUP_ID
AD_PARTNER_GROUP_MAP SYS_C002088108 PARTNER_ID
AD_PARTNER_PROCS SYS_C002088104 URL_ID
APM_PACKAGE_FILES APM_PACKAGE_FILES_TYPE_FK FILE_TYPE
APM_PACKAGE_OWNERS APM_PACKAGE_OWNERS_VER_ID_FK VERSION_ID
BBOARD SYS_C002087541 USPS_ABBREV
BBOARD SYS_C002087542 FIPS_COUNTY_CODE
BBOARD_BOZO_PATTERNS SYS_C002087529 CREATION_USER
BBOARD_EMAIL_ALERTS SYS_C002087546 TOPIC_ID
BBOARD_Q_AND_A_CATEGORIES SYS_C002087521 TOPIC_ID
BBOARD_THREAD_EMAIL_ALERTS SYS_C002087549 USER_ID
BBOARD_TOPICS SYS_C002087516 PRIMARY_MAINTAINER_ID
BBOARD_TOPICS SYS_C002087517 GROUP_ID
BBOARD_TOPICS SYS_C002087518 ICON_ID
BBOARD_UNIFIED SYS_C002087559 USER_ID
BBOARD_UNIFIED SYS_C002087560 TOPIC_ID
BBOARD_UNIFIED SYS_C002087561 ICON_ID
BM_LIST SYS_C002087869 OWNER_ID
BM_LIST SYS_C002087870 URL_ID
CALENDAR SYS_C002087483 CATEGORY_ID
CALENDAR SYS_C002087484 COUNTRY_CODE
CALENDAR SYS_C002087485 USPS_ABBREV
CALENDAR SYS_C002087486 CREATION_USER
CALENDAR_CATEGORIES SYS_C002087470 USER_ID
CATEGORY_HIERARCHY SYS_C002087172 CHILD_CATEGORY_ID
CHAT_ROOMS SYS_C002087781 PRIVATE_GROUP_ID
CLASSIFIED_ADS SYS_C002087586 DOMAIN_ID
CLASSIFIED_AUCTION_BIDS SYS_C002087591 USER_ID
CLASSIFIED_EMAIL_ALERTS SYS_C002087598 DOMAIN_ID
CLASSIFIED_EMAIL_ALERTS SYS_C002087599 USER_ID
CONTENT_SECTIONS SYS_C002087417 USER_ID
CONTENT_SECTIONS SYS_C002087418 GROUP_ID
CONTENT_SECTIONS SYS_C002087419 MODULE_KEY
CONTENT_SECTION_LINKS SYS_C002087432 TO_SECTION_ID
CONTENT_TAGS SYS_C002087797 CREATION_USER
CONTEST_DOMAINS SYS_C002087610 MAINTAINER
CONTEST_VOTES CONTEST_VOTES_DOMAIN_ID_FK DOMAIN_ID
CONTEST_VOTES CONTEST_VOTES_USER_ID_FK USER_ID
CRM_STATE_TRANSITIONS SYS_C002088055 NEXT_STATE
CSS_COMPLETE SYS_C002087631 USER_ID
CSS_COMPLETE SYS_C002087632 GROUP_ID
CSS_SIMPLE SYS_C002087622 USER_ID
CSS_SIMPLE SYS_C002087623 GROUP_ID
DOWNLOADS SYS_C002087655 CREATION_USER
DOWNLOAD_LOG SYS_C002087677 VERSION_ID
DOWNLOAD_LOG SYS_C002087678 USER_ID
DOWNLOAD_RULES SYS_C002087670 VERSION_ID
DOWNLOAD_RULES SYS_C002087671 DOWNLOAD_ID
DOWNLOAD_RULES SYS_C002087672 CURRENCY
DOWNLOAD_VERSIONS SYS_C002087664 DOWNLOAD_ID
DOWNLOAD_VERSIONS SYS_C002087665 CREATION_USER
EVENTS_ACTIVITIES SYS_C002088206 GROUP_ID
EVENTS_ACTIVITIES SYS_C002088207 CREATOR_ID
EVENTS_ACTIVITIES SYS_C002088208 DEFAULT_CONTACT_USER_ID
EVENTS_ACTIVITY_FIELDS SYS_C002088239 ACTIVITY_ID
EVENTS_ACTIVITY_ORG_ROLES EVNT_ACT_ROLE_ACTIVITY_ID_FK ACTIVITY_ID
EVENTS_EVENTS SYS_C002088229 ACTIVITY_ID
EVENTS_EVENTS SYS_C002088230 VENUE_ID
EVENTS_EVENTS SYS_C002088231 GROUP_ID
EVENTS_EVENTS SYS_C002088232 CREATOR_ID
EVENTS_EVENT_FIELDS SYS_C002088246 EVENT_ID
EVENTS_EVENT_ORGANIZER_ROLES EVNT_EV_ORG_ROLES_EVENT_ID_FK EVENT_ID
EVENTS_FILE_STORAGE SYS_C002088292 CREATED_BY
EVENTS_ORDERS SYS_C002088274 USER_ID
EVENTS_ORGANIZERS_MAP EVNT_ORG_MAP_ROLE_ID_FK ROLE_ID
EVENTS_PRICES SYS_C002088268 EVENT_ID
EVENTS_REGISTRATIONS SYS_C002088285 ORDER_ID
EVENTS_REGISTRATIONS SYS_C002088286 PRICE_ID
EVENTS_REGISTRATIONS SYS_C002088287 USER_ID
EVENTS_VENUES SYS_C002088213 ISO
EVENT_INFO SYS_C002088199 CONTACT_USER_ID
FAQ_Q_AND_A SYS_C002087724 FAQ_ID
FS_FILES SYS_C002087847 GROUP_ID
FS_FILES SYS_C002087848 OWNER_ID
FS_VERSIONS SYS_C002087855 AUTHOR_ID
FS_VERSIONS SYS_C002087856 SUPERSEDED_BY_ID
GENERAL_COMMENTS SYS_C002087883 GROUP_ID
GENERAL_LINKS SYS_C002087893 CREATION_USER
GENERAL_LINKS SYS_C002087894 LAST_MODIFYING_USER
GENERAL_LINKS SYS_C002087895 APPROVAL_CHANGE_BY
GENERAL_LINK_USER_RATINGS SYS_C002087914 USER_ID
GENERAL_PERMISSIONS SYS_C002087440 USER_ID
GENERAL_PERMISSIONS SYS_C002087441 GROUP_ID
GENERAL_PORTRAITS GP_UPOAD_USER_ID_FK UPLOAD_USER_ID
GLOSSARY SYS_C002087810 AUTHOR
GROUP_MEMBER_EMAIL_PREFERENCES SYS_C002087374 USER_ID
GROUP_SPAM_HISTORY SYS_C002087381 GROUP_ID
GROUP_SPAM_HISTORY SYS_C002087382 SENDER_ID
IM_ALLOCATIONS SYS_C002088460 START_BLOCK
IM_ALLOCATIONS SYS_C002088461 LAST_MODIFYING_USER
IM_ALLOCATIONS_AUDIT SYS_C002088468 GROUP_ID
IM_ALLOCATIONS_AUDIT SYS_C002088469 USER_ID
IM_ALLOCATIONS_AUDIT SYS_C002088470 START_BLOCK
IM_ALLOCATIONS_AUDIT SYS_C002088471 LAST_MODIFYING_USER
IM_CUSTOMERS SYS_C002088346 CUSTOMER_STATUS_ID
IM_CUSTOMERS SYS_C002088347 CUSTOMER_TYPE_ID
IM_CUSTOMERS SYS_C002088348 PRIMARY_CONTACT_ID
IM_CUSTOMERS SYS_C002088349 ANNUAL_REVENUE
IM_CUSTOMERS SYS_C002088350 OLD_CUSTOMER_STATUS_ID
IM_CUSTOMERS SYS_C002088351 MANAGER
IM_EMPLOYEE_INFO SYS_C002088398 FEATURED_EMPLOYEE_APPROVED_BY
IM_EMPLOYEE_INFO SYS_C002088400 REFERRED_BY_RECORDING_USER
IM_EMPLOYEE_INFO SYS_C002088401 EXPERIENCE_ID
IM_EMPLOYEE_INFO SYS_C002088402 SOURCE_ID
IM_EMPLOYEE_INFO SYS_C002088403 ORIGINAL_JOB_ID
IM_EMPLOYEE_INFO SYS_C002088404 CURRENT_JOB_ID
IM_EMPLOYEE_INFO SYS_C002088405 QUALIFICATION_ID
IM_EMPLOYEE_INFO SYS_C002088406 DEPARTMENT_ID
IM_EMPLOYEE_PERCENTAGE_TIME SYS_C002088433 USER_ID
IM_EMPLOYEE_PIPELINE SYS_C002088515 STATE_ID
IM_EMPLOYEE_PIPELINE SYS_C002088516 OFFICE_ID
IM_EMPLOYEE_PIPELINE SYS_C002088517 TEAM_ID
IM_EMPLOYEE_PIPELINE SYS_C002088518 PRIOR_EXPERIENCE_ID
IM_EMPLOYEE_PIPELINE SYS_C002088519 EXPERIENCE_ID
IM_EMPLOYEE_PIPELINE SYS_C002088520 SOURCE_ID
IM_EMPLOYEE_PIPELINE SYS_C002088521 JOB_ID
IM_EMPLOYEE_PIPELINE SYS_C002088522 RECRUITER_USER_ID
IM_EMPLOYEE_PIPELINE SYS_C002088523 REFERRED_BY
IM_EMP_CHECKPOINT_CHECKOFFS SYS_C002088509 CHECKPOINT_ID
IM_EMP_CHECKPOINT_CHECKOFFS SYS_C002088511 CHECKER
IM_FACILITIES IF_ADDRESS_COUNTRY_CODE_FK ADDRESS_COUNTRY_CODE
IM_FACILITIES SYS_C002088414 CONTACT_PERSON_ID
IM_OFFICES IM_OFFICES_FACILITY_ID FACILITY_ID
IM_OFFICE_LINKS IOL_GROUP_ID_FK GROUP_ID
IM_OFFICE_LINKS IOL_USERS_ID_FK USER_ID
IM_PARTNERS SYS_C002088475 PARTNER_TYPE_ID
IM_PARTNERS SYS_C002088476 PARTNER_STATUS_ID
IM_PARTNERS SYS_C002088477 PRIMARY_CONTACT_ID
IM_PARTNERS SYS_C002088478 ANNUAL_REVENUE
IM_PROCEDURES SYS_C002088484 CREATION_USER
IM_PROCEDURES SYS_C002088485 LAST_MODIFYING_USER
IM_PROCEDURE_EVENTS SYS_C002088500 PROCEDURE_ID
IM_PROCEDURE_EVENTS SYS_C002088501 USER_ID
IM_PROCEDURE_EVENTS SYS_C002088502 SUPERVISING_USER
IM_PROCEDURE_USERS SYS_C002088492 USER_ID
IM_PROCEDURE_USERS SYS_C002088493 CERTIFYING_USER
IM_PROJECTS SYS_C002088366 CUSTOMER_ID
IM_PROJECTS SYS_C002088367 PROJECT_TYPE_ID
IM_PROJECTS SYS_C002088368 PROJECT_STATUS_ID
IM_PROJECTS SYS_C002088369 PROJECT_LEAD_ID
IM_PROJECTS SYS_C002088370 SUPERVISOR_ID
IM_PROJECTS SYS_C002088371 TICKET_PROJECT_ID
IM_PROJECT_PAYMENTS SYS_C002088440 GROUP_ID
IM_PROJECT_PAYMENTS SYS_C002088441 START_BLOCK
IM_PROJECT_PAYMENTS SYS_C002088442 LAST_MODIFYING_USER
IM_PROJECT_PAYMENTS_AUDIT SYS_C002088448 GROUP_ID
IM_PROJECT_PAYMENTS_AUDIT SYS_C002088449 START_BLOCK
IM_PROJECT_PAYMENTS_AUDIT SYS_C002088450 LAST_MODIFYING_USER
IM_STATUS_REPORT_PREFERENCES ISRP_USER_ID_FK USER_ID
INTRANET_TASK_BOARD SYS_C002088528 POSTER_ID
INTRANET_TASK_BOARD SYS_C002088529 TIME_ID
LINKS SYS_C002087234 USER_ID
LINK_KILL_PATTERNS SYS_C002087239 PAGE_ID
LINK_KILL_PATTERNS SYS_C002087240 USER_ID
MANUALS SYS_C002088622 OWNER_ID
MANUALS SYS_C002088623 GROUP_ID
MANUAL_SECTIONS SYS_C002088635 CREATOR_ID
MANUAL_SECTIONS SYS_C002088636 LAST_MODIFIED_BY
NAUGHTY_EVENTS SYS_C002087800 CREATION_USER
NEIGHBOR_TO_NEIGHBOR_AUDIT SYS_C002087765 POSTER_USER_ID
NEWS_ITEMS SYS_C002087461 APPROVAL_USER
NEWS_ITEMS SYS_C002087462 CREATION_USER
N_TO_N_PRIMARY_CATEGORIES SYS_C002087745 PRIMARY_MAINTAINER_ID
N_TO_N_SUBCATEGORIES SYS_C002087750 CATEGORY_ID
PAGE_LOGOS SYS_C002087641 USER_ID
PAGE_LOGOS SYS_C002087642 GROUP_ID
PDM_MENU_ITEMS SYS_C002088341 MENU_ID
POLL_USER_CHOICES SYS_C002088196 USER_ID
PORTAL_PAGES SYS_C002088037 GROUP_ID
PORTAL_PAGES SYS_C002088038 USER_ID
PORTAL_TABLES SYS_C002088035 CREATION_USER
PORTAL_TABLES_AUDIT SYS_C002088044 CREATION_USER
PORTAL_TABLE_PAGE_MAP SYS_C002088040 PAGE_ID
PORTAL_TABLE_PAGE_MAP SYS_C002088041 TABLE_ID
PRESS SYS_C002088085 GROUP_ID
PRESS SYS_C002088086 TEMPLATE_ID
PRESS SYS_C002088087 CREATION_USER
QUERIES SYS_C002087709 QUERY_OWNER
SEC_SESSIONS SYS_C002087388 USER_ID
SITE_WIDE_LINK_MAP SYS_C002087905 LINK_ID
SITE_WIDE_LINK_MAP SYS_C002087906 CREATION_USER
SITE_WIDE_LINK_MAP SYS_C002087907 LAST_MODIFYING_USER
SITE_WIDE_LINK_MAP SYS_C002087908 APPROVAL_CHANGE_BY
SPAM_HISTORY SYS_C002087736 CREATION_USER
SPAM_HISTORY SYS_C002087737 LAST_USER_ID_SENT
STATIC_PAGES SYS_C002087202 ORIGINAL_AUTHOR
STATIC_PAGE_AUTHORS SYS_C002087208 USER_ID
STATIC_PAGE_INDEX_EXCLUSION SYS_C002087217 CREATION_USER
STOLEN_REGISTRY SYS_C002087730 USER_ID
SURVSIMP_QUESTIONS SYS_C002088573 SURVEY_ID
SURVSIMP_QUESTIONS SYS_C002088574 CREATION_USER
SURVSIMP_QUESTION_CHOICES SYS_C002088579 QUESTION_ID
SURVSIMP_QUESTION_RESPONSES SYS_C002088593 QUESTION_ID
SURVSIMP_QUESTION_RESPONSES SYS_C002088594 CHOICE_ID
SURVSIMP_RESPONSES SYS_C002088586 SURVEY_ID
SURVSIMP_RESPONSES SYS_C002088587 USER_ID
SURVSIMP_RESPONSES SYS_C002088588 GROUP_ID
SURVSIMP_SURVEYS SYS_C002088561 CREATION_USER
TABLE_ACS_PROPERTIES SYS_C002087126 MODULE_KEY
TICKET_ASSIGNMENTS SYS_C002087976 DOMAIN_ID
TICKET_ASSIGNMENTS SYS_C002087977 USER_ID
TICKET_CODE_SETS SYS_C002087934 CODE_ID
TICKET_DOMAINS SYS_C002087962 CREATED_BY
TICKET_DOMAINS SYS_C002087963 DEFAULT_ASSIGNEE
TICKET_DOMAINS SYS_C002087964 GROUP_ID
TICKET_DOMAIN_PROJECT_MAP SYS_C002087970 DOMAIN_ID
TICKET_DOMAIN_PROJECT_MAP SYS_C002087971 DEFAULT_ASSIGNEE
TICKET_DOMAIN_PROJECT_MAP SYS_C002087972 ASSIGNMENT_GROUP_ID
TICKET_EMAIL_ALERTS SYS_C002088016 USER_ID
TICKET_EMAIL_ALERTS SYS_C002088017 MSG_ID
TICKET_EMAIL_ALERTS SYS_C002088018 DOMAIN_ID
TICKET_EMAIL_ALERTS SYS_C002088019 PROJECT_ID
TICKET_ISSUES_I SYS_C002087988 PROJECT_ID
TICKET_ISSUES_I SYS_C002087989 DOMAIN_ID
TICKET_ISSUES_I SYS_C002087990 USER_ID
TICKET_ISSUES_I SYS_C002087991 COMMENT_ID
TICKET_ISSUES_I SYS_C002087992 TICKET_TYPE_ID
TICKET_ISSUES_I SYS_C002087993 PRIORITY_ID
TICKET_ISSUES_I SYS_C002087994 STATUS_ID
TICKET_ISSUES_I SYS_C002087995 SEVERITY_ID
TICKET_ISSUES_I SYS_C002087996 SOURCE_ID
TICKET_ISSUES_I SYS_C002087997 CAUSE_ID
TICKET_ISSUES_I SYS_C002087998 CLOSED_BY
TICKET_ISSUES_I SYS_C002087999 LAST_MODIFYING_USER
TICKET_ISSUE_ASSIGNMENTS SYS_C002088025 USER_ID
TICKET_ISSUE_NOTIFICATIONS SYS_C002088032 USER_ID
TICKET_PROJECTS SYS_C002087946 CREATED_BY
TICKET_PROJECTS SYS_C002087947 GROUP_ID
TICKET_XREFS SYS_C002088026 FROM_TICKET
TICKET_XREFS SYS_C002088027 TO_TICKET
USERS SYS_C002087138 APPROVING_USER
USERS SYS_C002087139 REJECTING_USER
USERS SYS_C002087140 DELETING_USER
USERS SYS_C002087141 BANNING_USER
USERS_CHARGES SYS_C002087829 ADMIN_ID
USERS_CHARGES SYS_C002087830 ORDER_ID
USERS_CONTACT SYS_C002087159 HA_COUNTRY_CODE
USERS_CONTACT SYS_C002087160 WA_COUNTRY_CODE
USERS_CONTENT_TYPES SYS_C002088307 OWNER_ID
USERS_CONTENT_TYPES SYS_C002088308 SUB_TYPE
USERS_CONTENT_TYPES SYS_C002088309 SUPER_TYPE
USERS_DEMOGRAPHICS SYS_C002087154 HA_COUNTRY_CODE
USERS_DEMOGRAPHICS SYS_C002087155 REFERRED_BY
USERS_FILES SYS_C002088318 CONTENT_TYPE
USERS_FILES_ACCESS_LOG SYS_C002088325 FILE_ID
USERS_FILES_ACCESS_LOG SYS_C002088326 OWNER_ID
USERS_HOMEPAGES SYS_C002088298 NEIGHBORHOOD_ID
USERS_INTERESTS SYS_C002087187 CATEGORY_ID
USERS_NEIGHBORHOODS SYS_C002088295 PARENT_ID
USERS_ORDERS SYS_C002087823 USER_ID
USERS_PAYMENT SYS_C002087817 SUBSCRIBER_CLASS
USER_CONTENT_MAP SYS_C002087246 PAGE_ID
USER_CURRICULUM_MAP SYS_C002088072 CURRICULUM_ELEMENT_ID
USER_GROUPS SYS_C002087307 GROUP_TYPE
USER_GROUPS SYS_C002087308 CREATION_USER
USER_GROUPS SYS_C002087309 MODIFYING_USER
USER_GROUP_ACTIONS SYS_C002087336 CREATION_USER
USER_GROUP_ACTION_ROLE_MAP SYS_C002087345 CREATION_USER
USER_GROUP_MAP SYS_C002087318 USER_ID
USER_GROUP_MAP SYS_C002087319 MAPPING_USER
USER_GROUP_MAP_QUEUE SYS_C002087322 USER_ID
USER_GROUP_MEMBER_FIELD_MAP SYS_C002087363 USER_ID
USER_GROUP_ROLES SYS_C002087329 CREATION_USER
USER_GROUP_TYPE_FIELDS SYS_C002087288 GROUP_TYPE
USER_GROUP_TYPE_MODULES_MAP SYS_C002087367 GROUP_TYPE
USER_GROUP_TYPE_MODULES_MAP SYS_C002087368 MODULE_KEY
USER_USER_BOZO_FILTER SYS_C002087272 TARGET_USER_ID
WAP_USER_AGENTS WAP_USER_AGT_CREATE_USER_FK CREATION_USER
WAP_USER_AGENTS WAP_USER_AGT_DELETE_USER_FK DELETION_USER
WP_PRESENTATIONS SYS_C002088134 CREATION_USER
WP_PRESENTATIONS SYS_C002088135 STYLE
WP_PRESENTATIONS SYS_C002088136 GROUP_ID
WP_SLIDES SYS_C002088150 ORIGINAL_SLIDE_ID
WP_SLIDES SYS_C002088151 STYLE
WP_SLIDES SYS_C002088152 PRESENTATION_ID, MIN_CHECKPOINT
WP_STYLES SYS_C002088127 STYLE_ID, BACKGROUND_IMAGE
WP_USER_ACCESS_TICKET SYS_C002088178 PRESENTATION_ID
WP_USER_ACCESS_TICKET SYS_C002088179 INVITE_USER

Generated by OraSchemaDoc, (c) Aram Kananov, 2002