-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Trivial - P5
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Fully Compatible
-
None
-
None
-
None
-
None
-
None
-
None
-
None
In SERVER-113732, we decided that when a query is not eligible for join optimization, but the join optimization flag is enabled, we should include "usedJoinOptimization":false in the explain output. This does not occur if the base collection uses an express plan.
For example
db.foo.explain().aggregate([{$match: {_id: 0}}, {$lookup: {from: "bar", localField: "a", foreignField: "a", as: "res" }}])
This query is not eligible for join optimization because it’s missing an $unwind, so when the join opt flag is enabled, we would expect to see "usedJoinOptimization":false in the explain output, but it is missing.
- is related to
-
SERVER-113732 Add bit to explain to indicate whether the join optimizer was used
-
- Closed
-