[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:
Related
related to SERVER-81863 Avoid a scan of either IDX or a colle... Closed
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.

 

 


Generated at Thu Feb 08 06:49:26 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.