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

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

              Created:
              Updated:
              Resolved: