Uploaded image for project: 'FTS'
  1. FTS
  2. FTS-1087

Modify Optimizer queries to use the idx_finish_time index

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: fts 3.7.6
    • Fix Version/s: fts 3.7.7
    • Component/s: MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • Labels:
      None

      Description

      create index idx_finish_time on t_file(finish_time, source_se, dest_se);
      this is to speed up one of the Optimizer queries

        Attachments

          Activity

            People

            Assignee:
            amanzi Andrea Manzi (Inactive)
            Reporter:
            amanzi Andrea Manzi (Inactive)
            Component Watchers:
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: