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

no index created for AuditTaskImpl table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.11.0.Final
    • 7.10.0.Final
    • Runtime Engine
    • None
    • 2
    • NEW
    • NEW
    • 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);

              rhn-support-tsurdilo Tihomir Surdilovic (Inactive)
              rhn-support-tsurdilo Tihomir Surdilovic (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: