merge sequential $project stages and $addFields stages when appropriate

XMLWordPrintableJSON

    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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"}}

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Adinoyi Omuya (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated: