-
Type: Improvement
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
QO 2024-02-05, QO 2024-02-19, QO 2024-03-04, QO 2024-03-18, QO 2024-04-01, QO 2024-04-15, QO 2024-04-29, QO 2024-05-13, QO 2024-05-27, QO 2024-06-10, QO 2024-06-24, QO 2024-07-08, QO 2024-07-22, QO 2024-08-05, QO 2024-08-19, QO 2024-09-02, QO 2024-09-16, QO 2024-09-30
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.
- is fixed by
-
SERVER-92359 [SBE] Produce EOF plan for pushed down $lookup when outer collection does not exist
- Closed
- related to
-
SERVER-94906 Complete TODO listed in SERVER-82497
- Open
-
SERVER-81863 Avoid a scan of either IDX or a collection if the filter is $alwaysFalse:
- Closed