-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Guide in comments. TSF1Q1 and ** TUF3Q1 place a $sort/$limit at the start of the pipeline, which makes the queries join-opt ineligible/ fast on classic. After work to support $limit and maybe after SERVER-121078, we should see if we can rewrite these queries to place the $limit/$sort at the end of the pipeline.
- is related to
-
SERVER-121078 Join optimization: non-join-optimization-enabled NLJ execution may win against HJ in the case of $limit
-
- Open
-