-
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
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.
- backported by
-
SERVER-84667 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 indexes
- Backlog