- 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
- querying by TIMESTAMP_ in ACT_HI_IDENTITYLINK table does not end up in full table scan
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.