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

Add indexes on PROC_DEF_KEY_ columns in history tables

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.6.0, 7.6.0-alpha4
    • None
    • engine
    • None

      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.

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: