Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-7667

no index created for AuditTaskImpl table

    Details

    • Sprint:
      2018 Week 33-35
    • Story Points:
      2
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      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);

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tsurdilovic Tihomir Surdilovic
                  Reporter:
                  tsurdilovic Tihomir Surdilovic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: