They found out wrong/suboptimal execution plans while inquiring the table CASEROLEASSIGNMENTLOG that resulted accessed using Full Table Access. Adding the following indexes dramatically improves performances:

• • CASEROLEASSIGNMENTLOG: caseId, processInstanceId

• • CASEFILEDATALOG: caseId and itemName;

• • CORRELATIONKEYINFO: name