-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
QE 2022-02-07, QE 2022-02-21
We must add logic to the query planner for planning a $lookup. This involves examining the size of the collections involved and choosing the join algorithm (nlj or hashed) using the heuristic we agreed on here:
Foreign collection has index to answer join predicate? | Size of foreign collection | Strategy |
Yes | Anything | Indexed NLJ |
No | < 10k docs | Hash Join (foreign side is build side) |
No | >= 10k docs | NLJ |
- is depended on by
-
SERVER-63262 Use MultiCollection in place of CollectionPtr in the stage builder
- Closed
- mentioned in
-
Page Loading...