Add new index for ACT_RU_JOB table

XMLWordPrintable

    • Type: Task
    • Resolution: Won't Fix
    • Priority: L3 - Default
    • None
    • Affects Version/s: 7.8.0
    • Component/s: engine

      Verify the following index and include it if it works for all databases and improve the query performance.

      create index IDX_LOCK_EXP_TIME_ACT_RU_JOB on ACT_RU_JOB("LOCK_EXP_TIME_") ;
      
      create index IDX_SUSP_STATE_RETRIES_ACT_RU_JOB on ACT_RU_JOB("SUSPENSION_STATE_","RETRIES_");
      

        This is the controller panel for Smart Panels app

              Assignee:
              Unassigned
              Reporter:
              Philipp Ossler
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: