Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-760

Add indexes to foreign keys where appropriate

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • jBPM 3.2.0
    • jBPM 3.2.0
    • Runtime Engine
    • None
    • Documentation (Ref Guide, User Guide, etc.)
    • 0
    • 0% 0%

    Description

      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_);

      Attachments

        Issue Links

          Activity

            People

              tom.baeyens Tom Baeyens (Inactive)
              jeffdelong Jeff DeLong (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: