Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-6679

Add indexes on PROC_DEF_KEY_ columns in history tables

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.6.0, 7.6.0-alpha4
    • Component/s: engine
    • Labels:
      None

      Description

      With active authorization checks, the history queries perform sub selects to select all distinct process definition keys in order to join them with the authorization table (e.g. SELECT DISTINCT DKEYS.PROC_DEF_KEY_ from ${prefix}ACT_HI_ACTINST DKEYS for historic activity instances).

      We should create indexes for these columns so that this sub-select can be answered without a full table scan.

        Attachments

          Activity

            People

            Assignee:
            thorben.lindhauer Thorben Lindhauer
            Reporter:
            thorben.lindhauer Thorben Lindhauer
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: