[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: |
|
||||||||
| 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. |