-
Bug
-
Resolution: Done
-
Major
-
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);
- is blocked by
-
JBPM-7667 no index created for AuditTaskImpl table
- Resolved
- is cloned by
-
RHPAM-1468 [GSS](7.0.z)no index created for AuditTaskImpl table
- Closed
-
RHPAM-1469 [GSS](6.4.z) no index created for AuditTaskImpl table
- Closed