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

[Tom Baeyens (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPM-760?page=all ]

Tom Baeyens closed JBPM-760.
----------------------------

    Fix Version/s: jBPM 3.2 alpha 2
       Resolution: Done

Jeff i didn't find this issue when resolving the problem yesterday.  I just did a good effort of trying to add many indexes on each many-to-one where i thought it was possibly being used in a query.

I think i have many more indexes defined then you have specified.  If you have a chance, could you have a look and see in the scripts if the once i created make sense ?

> 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
>             Fix For: jBPM 3.2 alpha 2
>
>
> 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