-
Type:
New Feature
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
Labels:
-
Query Optimization
Consider
{"$project": {"__joinedPipeline_1_c":"$c","__joinedPipeline_1_e":"$e","_id":"$__joined_bar._id","c":"$__joined_bar.c"}},
{"$project": {"__joinedPipeline_1_c":1,"__joinedPipeline_1_e":1,"_id":1,"bar_DOT__id":"$_id","bar_DOT_c":"$c","c":1}},
{"$project":{"bar_DOT_c":"$c","foo_DOT_e":"$__joinedPipeline_1_e"}}
The pipeline can be consolidated into a single $project stage:
{"$project":{"bar_DOT_c":"$__joined_bar.c","foo_DOT_e":"$e"}}
- is duplicated by
-
SERVER-29010 Coalesce adjacent exclusion $project stages and non-overlapping $addFields stages
-
- Closed
-
- related to
-
SERVER-54078 [SBE] Improve perf of the bestbuy_agg_merge_wordcount benchmark suite
-
- Closed
-