-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
3
-
TBD
-
None
-
None
-
None
-
None
-
None
-
None
-
None
In HELP-77368 we saw that SERVER-105375 caused some {$elemMatch: {$in: []}} queries to not use an index on 8.0, while on 7.0 they did use an index. This caused severe performance regressions.
To provide some safety in plan choice stability, we can write a property-based test which runs explain on different versions of mongo and checks for similarities in the plans considered. A PBT that only looked for collscan vs no collscan was able to repro SERVER-105375.
This test may provide some safety in the future, since it likely would have failed before the 8.0 release and given us a warning that customers could hit perf issues like HELP-77368
- related to
-
SERVER-105375 Use EOF plan for alwaysFalse expressions within elemMatch
-
- Closed
-