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

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: 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
    • 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.

        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
              Reporter:
              y yz
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: