[jboss-jira] [JBoss JIRA] Created: (JBPM-760) Add indexes to foreign keys where appropriate

[Jeff DeLong (JIRA)]

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