-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
Fully Compatible
-
v7.0
-
QE 2023-09-18, QE 2023-10-02, QE 2023-10-16
-
(copied to CRM)
-
170
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
-
None
A $in query with multiple index choice and empty result is much slower after 6.3 upgrade, from the explain output we can tell that the problem is from SBE multi-planner. One of the predicate is an empty $in predicate descriptionRef:{ $in: []}{}, we should think about whether there's anything we can do to improve the performance of the multi-planner in this scenario.
- is related to
-
MONGOID-5030 Opinionated short-circuiting of specific query shapes
-
- Backlog
-
- related to
-
-
- Backlog
-