-
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
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
-
SERVER-81637 Trial metrics should use boost::optional instead of 0 to indicate metric is not tracked
- Backlog