Add indexes to foreign keys where appropriate --------------------------------------------- Key: JBPM-760 URL: http://jira.jboss.com/jira/browse/JBPM-760 Project: JBoss jBPM Issue Type: Feature Request Components: Core Engine Affects Versions: jBPM 3.2 Reporter: Jeff DeLong Assigned To: Tom Baeyens create index IDX_MODDEF_PROCDEF on JBPM_MODULEDEFINITION (PROCESSDEFINITION_); create index IDX_MODINST_PRCINST on JBPM_MODULEINSTANCE (PROCESSINSTANCE_); create index IDX_NODE_ACTION on JBPM_NODE (ACTION_); create index IDX_PROCIN_ROOTTKN on JBPM_PROCESSINSTANCE (ROOTTOKEN_); create index IDX_TASK_TASKNODE on JBPM_TASK (TASKNODE_); create index IDX_TSK_TSKCTRL on JBPM_TASK (TASKCONTROLLER_); create index IDX_TASK_TASKMGTDEF on JBPM_TASK (TASKMGMTDEFINITION_); create index IDX_TASKINST_TASK on JBPM_TASKINSTANCE (TASK_, TOKEN_); create index IDX_TASKINST_TMINST on JBPM_TASKINSTANCE (TASKMGMTINSTANCE_); create index IDX_TOKEN_NODE on JBPM_TOKEN (NODE_); create index IDX_TOKEN_PROCINST on JBPM_TOKEN (PROCESSINSTANCE_); create index IDX_TOKEN_PARENT on JBPM_TOKEN (PARENT_); create index IDX_TKVARMAP_CTXT on JBPM_TOKENVARIABLEMAP (CONTEXTINSTANCE_); create index IDX_TKVARMAP_TOKEN on JBPM_TOKENVARIABLEMAP (TOKEN_); create index IDX_VARINST_TKVARMP on JBPM_VARIABLEINSTANCE (TOKENVARIABLEMAP_); create index IDX_VARINST_PRCINST on JBPM_VARIABLEINSTANCE (PROCESSINSTANCE_); create index IDX_VARINST_TK on JBPM_VARIABLEINSTANCE (TOKEN_); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira