[DOCS-15704] Investigate changes in SERVER-67024: Re-enable NLJ for $lookup pushed down into SBE Created: 26/Oct/22  Updated: 13/Nov/23  Resolved: 10/Feb/23

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 6.2.0-rc0, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Alison Huh
Resolution: Won't Do Votes: 0
Labels: ready-for-work
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-67024 Re-enable NLJ for $lookup pushed down... Closed
Participants:
Days since reply: 51 weeks, 5 days ago
Epic Link: DOCSP-22091

 Description   
Original Downstream Change Summary

This ticket will expand the cases in which $lookup can be pushed down and executed in SBE.

Description of Linked Ticket

Once SERVER-65960 is merged, the use of NLJ will be hidden behind 'featureFlagSbeFull' ($lookups eligible for NLJ will fall back to the classic engine instead). This ticket tracks the work to re-enable NLJ once the performance improves.



 Comments   
Comment by Alison Huh [ 10/Feb/23 ]

After discussion with Chris, there doesn't seem to be a compelling reason to share specific implementation details about NLJ and $lookup in the public docs regarding SBE. 

Closing this ticket as a result, but feel free to ping if this should/needs to be re-opened.

Comment by Education Bot [ 27/Oct/22 ]

Fix Version updated for upstream SERVER-67024:
6.2.0-rc0

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