Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
-
QO 2024-02-05, QO 2024-02-19
Description
When planning left branch of `$lookup` stages in pipelines, an `EQ_LOOKUP` stage is put at the root, fed by whichever plan the planner came up with.
If such inner plan is an EOF we shouldn't generate the `EQ_LOOKUP` one since that's a waste.
Attachments
Issue Links
- related to
-
SERVER-81863 Avoid a scan of either IDX or a collection if the filter is $alwaysFalse:
-
- Closed
-