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

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

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Storage Execution
    • ALL
    • Execution Team 2023-12-11, Execution Team 2024-01-08, Execution Team 2024-01-22

      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.

        1. image-2023-06-18-15-32-00-192.png
          image-2023-06-18-15-32-00-192.png
          24 kB
        2. image-2023-06-18-15-41-49-632.png
          image-2023-06-18-15-41-49-632.png
          52 kB
        3. image-2023-06-18-15-42-34-344.png
          image-2023-06-18-15-42-34-344.png
          59 kB

            Assignee:
            daotang.yang@mongodb.com Daotang Yang
            Reporter:
            1147952115@qq.com y yz
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: