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

Add indexes on PROC_DEF_KEY_ columns in history tables

    XMLWordPrintable

Details

    • Task
    • Status: Closed
    • L3 - Default
    • Resolution: Fixed
    • None
    • 7.6.0, 7.6.0-alpha4
    • engine
    • 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.

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce