index check, avoid create duplicate btree indexes, Avoid affecting performance and increases storage consts.

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Incomplete
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • ALL
    • Execution Team 2024-01-22, Execution Team 2024-02-05
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      btree index check, avoid create duplicate btree indexes, Avoid affecting performance

      btree index check, avoid create duplicate btree indexes, Avoid affecting performance by the deplicate index.
      for example:
      add two index: db.collection.createIndex({a:1}) and db.collection.createIndex({a:11})
      the tow index are actually the same, One of them is a useless index, but it can affect the insert performance.

      In addition, They also affecting query performance because both are candidate indexes. This increases storage consts.

              Assignee:
              Daotang Yang
              Reporter:
              y yz
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: