Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-84667

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

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

      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@mongodb.com Daotang Yang
            Reporter:
            1147952115@qq.com y yz
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: