Adding indexes in tables: CaseRoleAssignmentLog, CaseFileDataLog and CorrelationKeyInfo
Issue
- Wrong execution plans while inquiring the table CaseRoleAssignmentLog resulted using Full Table Access.
- Some RHPAM database tables do not use indexes to access, resulting in long execution times;
-
The following indexes dramatically improve the performance:
* CaseRoleAssignmentLog: caseId, processInstanceId * CaseFileDataLog: caseId and itemName; * CorrelationKeyInfo: name
Environment
- Red Hat Process Automation Manager (RHPAM) 7.10
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.