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

Add indexes to foreign keys where appropriate

XMLWordPrintable

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

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

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

                Created:
                Updated:
                Resolved: