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

Add indexes for date fields on ACT_HI_INCIDENT table

XMLWordPrintable

      AT:

      • the following indexes are added for all sql scrips:
        • create index ACT_HI_INCIDENT on ACT_HI_INCIDENT(CREATE_TIME_);
        • create index ACT_HI_INCIDENT on ACT_HI_INCIDENT(END_TIME_);
      • the sql update scripts are adjusted accordingly

      So that:

      • querying by CREATE_TIME_/END_TIME_ in ACT_HI_INCIDENT table does not end up in full table scan

      Context:
      In Optimize, we want to create new reports that allow users to get insights to how many incidents occurred in certain tasks, are open, or how long it took to resolve them. When retrieving the historic incident data, the data is sorted by creation/end time. So in order for Optimize to retrieve the data efficiently, we need to add the indexes.

        This is the controller panel for Smart Panels app

              thorben.lindhauer Thorben Lindhauer
              johannes.heinemann Johannes
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: