-
Bug
-
Resolution: Done
-
Major
-
7.10.0.Final
-
None
-
2
-
NEW
-
NEW
-
2018 Week 33-35
There's no indexes created for the AuditTaskImpl table. This results in full table scan and causes performance issues.
Can we add additional indexes to this table?
create index IDX_AuditTaskImpl_taskId on AuditTaskImpl(taskId);
create index IDX_AuditTaskImpl_processInstanceId on AuditTaskImpl(processInstanceId);
create index IDX_AuditTaskImpl_workItemId on AuditTaskImpl(workItemId);
create index IDX_AuditTaskImpl_name on AuditTaskImpl(name);
create index IDX_AuditTaskImpl_processId on AuditTaskImpl(processId);
create index IDX_AuditTaskImpl_status on AuditTaskImpl(status);
- blocks
-
RHPAM-1467 no index created for AuditTaskImpl table
- Closed