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

Drop inefficient index ISSUES_SEVERITY

    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 on ISSUES.SEVERITY is never used in queries.
      The number distinct values is very low (5) and the query search never used this value like a discriminatory factor (SEVERITY=BLOCKER)
      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:
            2 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: