Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-1468

[GSS](7.0.z)no index created for AuditTaskImpl table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 7.0.2.GA
    • jBPM Core
    • 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);

            swiderski.maciej Maciej Swiderski (Inactive)
            rhn-support-ghu Gary Hu
            Marian Macik Marian Macik
            Marian Macik Marian Macik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: