Evaluate if ACT_HI_ACTINST.PROC_DEF_KEY index speeds up history queries with authorization

XMLWordPrintable

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

      History queries select a distinct set of process definition keys before joining the authorization table. We have evidence that an index on the process definition key column improves performance on 7.4 (with ~5 million historic activity instances). Let's check whether this also improves performance for the reworked history queries on the master branch.

            Assignee:
            Sebastian Menski
            Reporter:
            Thorben Lindhauer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: