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

Drop unused DB indexes DUPLICATION_INDEX_PSID

    XMLWordPrintable

    Details

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

      Description

      The index DUPLICATIONS_INDEX_PSID is never used in the queries. Indeed when the hash value is provided the index based on the column hash is always chosen (even if the value PSID is involved).
      In the opposite case (full search) , the full scan table is the best option for the optimizer.
      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: