Add index for TASK_ID on ACT_HI_OP_LOG table

XMLWordPrintable

      AT:

      • the following index is added for all sql scrips:
        • create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG( TASK_ID_);
      • the sql update scripts are adjusted accordingly

      So that:

      • querying by TASK_ID_ in ACT_HI_OP_LOG table does not end up in full table scan

        This is the controller panel for Smart Panels app

              Assignee:
              Nikola Koevski
              Reporter:
              Johannes
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: