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

Redundant indexes

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • fts 3.6.0
    • None
    • MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • None

    Description

      There may be some indexes that are unused, or redundant.
      For instance, an index for (a) and and index for (a,b) are redundant, since (a,b) can be used for (a)

      Additional unnecessary indexes add load for nothing.

      Attachments

        Issue Links

          has to be started together with

          Improvement - An improvement or enhancement to an existing feature or task. FTS-598 Drop unused columns

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is child task of

          Improvement - An improvement or enhancement to an existing feature or task. FTS-599 Optimize database schema

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              aalvarez Alejandro Alvarez Ayllon (Inactive)
              aalvarez Alejandro Alvarez Ayllon (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: