[SERVER-82497] Optimize SBE EOF plans when in $lookup stages of pipelines Created: 27/Oct/23 Updated: 02/Feb/24 |
|
| Status: | Open |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Carlos Alonso Pérez | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | neweng | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Optimization
|
||||||||
| Sprint: | QO 2024-02-05, QO 2024-02-19 | ||||||||
| Participants: | |||||||||
| 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.
|