Details
-
Bug
-
Resolution: Done
-
Major
-
7.0.2.GA
-
None
Description
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);
Attachments
Issue Links
- 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