-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
QE 2025-05-26, QE 2025-06-09, QE 2025-06-23, QE 2025-07-07, QE 2025-07-21, QE 2025-08-04, QE 2025-08-18, QE 2025-09-01, QE 2025-09-15, QE 2025-09-29, QE 2025-10-13, QE 2025-10-27, QE 2025-11-10
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
0
Currently SBE handles only $lookup stages where the join is performed as an equi-join between localField and foreignField path expressions. The optimizer can extend this syntax to include also a pipeline holding a $match to be performed on the foreign collection to trim its results during the scan.
Improvement #1: convert the MatchExpression held by the $match stage into SBE code to be executed on top of the filtering done to enforce the equijoin constraint
Improvement #2: if the $match expression is an $expr with a single $eq, or a top-level $and with at least one $eq children, pull up those equalities and add them to the equijoin constraints (including declaring any required variable defined in the let field of the $lookup)
- is depended on by
-
SERVER-111154 Extend SBE $lookup to handle custom pipelines containing a prefix of $match stages
-
- Backlog
-