-
Type:
Bug
-
Status: Verified (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: 7.0.2.GA
-
Fix Version/s: 7.1.0.GA
-
Component/s: jBPM Core
-
Labels:None
-
Target Release:
-
Fix Build:CR2
-
Story Points:1
-
Git Pull Request:
-
Sprint: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);
- cloned to
-
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
-
- is blocked by
-
JBPM-7667 no index created for AuditTaskImpl table
-
- Resolved
-