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

Add index for TIMESTAMP_ on ACT_HI_IDENTITYLINK table

    Details

      Description

      AT:

      • the following index is added for all sql scrips:
        create index ACT_HI_IDENTITYLINK on ACT_HI_IDENTITYLINK(TIMESTAMP_);
      • the sql update scripts are adjusted accordingly

      So that:

      • querying by TIMESTAMP_ in ACT_HI_IDENTITYLINK table does not end up in full table scan

      Context:
      In Optimize we want to group user task information by assignee, candidate users and candidate group. In order to do that we need the historic identity links, since those contain the candidate users and candidate group information. When retrieving the historic identity link data, the data is sorted by timestamp. So in order for Optimize to retrieve the data efficiently, we need to add the index.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            johannes.heinemann Johannes Heinemann
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development