Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-7378

Drop unused index ISSUES_STATUS

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5
    • Component/s: Database
    • Labels:

      Description

      The following index :

      CREATE INDEX NEMO.ISSUES_STATUS ON NEMO.ISSUES (STATUS);
      

      is never used in the queries. Indeed the query search is based on the different values except "CLOSED" and the optimizer engine always make a full table scan to the find the right rows. The index is never used.
      I recommend to drop this index.

        Attachments

          Activity

            People

            Assignee:
            eric.duquesnoy Eric Duquesnoy (Inactive)
            Reporter:
            eric.duquesnoy Eric Duquesnoy (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: