-
Type: Task
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
To support $lookup using an indexed nested loop join, we will need some way to run an index scan using bounds that are not known until runtime. The bounds will be provided as a correlated value from the left side of the join.
This work will involve changing sbe_stage_builder_index_scan to support cases where the bounds are provided via slots, rather than as IndexBounds known at compile time.
- is duplicated by
-
SERVER-63572 Index SBEPlan: Translate EqLookup for scalar values on non-hashed indexes
- Closed