-
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
-
-
- Closed
-
- related to
-
SERVER-94906 Complete TODO listed in SERVER-82497
-
- Needs Scheduling
-
-
-
- Closed
-