Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
-
Fully Compatible
-
QO 2023-10-16, QO 2023-10-30, QO 2023-11-13, QO 2023-11-27
-
120
Description
Irina suggested in this comment that {$in: []} is tautologically "false" so it would be nice to optimize the plan to "return an empty result right away" rather than scanning anything.
Attachments
Issue Links
- depends on
-
SERVER-81863 Avoid a scan of either IDX or a collection if the filter is $alwaysFalse:
-
- Closed
-