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

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

    XMLWordPrintable

Details

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

    Description

      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.

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              sebastian.menski Sebastian Menski
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce