-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
7.0.2.GA
-
None
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);
- clones
-
RHPAM-1467 no index created for AuditTaskImpl table
- Closed