Add indexes on PROC_DEF_KEY_ columns in history tables

XMLWordPrintable

    • Type: Task
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.6.0, 7.6.0-alpha4
    • Affects Version/s: None
    • Component/s: 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

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

                Created:
                Updated:
                Resolved: