[SERVER-42337] Use better join algorithms for $lookup Created: 22/Jul/19  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Sam Mercier Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 3
Labels: bonsai
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-58131 Push down $lookup through $_internalU... Backlog
Assigned Teams:
Query Execution
Participants:

 Description   

We should probably use better join algorithms (e.g. hash join/sort-merge join) where appropriate.



 Comments   
Comment by David Storch [ 25/Feb/22 ]

Re-opening this ticket. This is something that we do intend to implement, and are starting on now with the project to execute some $lookup stages in SBE. We probably would schedule this work under different tickets related to projects in the Common Query Framework initiative, but it still makes sense to leave this ticket open for tracking purposes.

Generated at Thu Feb 08 05:00:13 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.