-
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
-
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.
- backports
-
SERVER-78199 btree index check, avoid create duplicate btree indexes, Avoid affecting performance and increases storage consts.
-
- Closed
-
- is related to
-
SERVER-27464 Server allows creation of duplicate/redundant indexes
-
- Backlog
-