leading $facet with each facet beginning with $match should add $match before $facet

XMLWordPrintableJSON

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

      Imagine you have an aggregation pipeline that looks something like:

      db.collection.aggregate([
  {$facet: {
    xs: [
      {$match: {x: "SOMETHING"}},
      {$group: {...}}
    ],
    ys: [
      {$match: {y: "SOMETHING ELSE"}},
      {$unwind: "$y"},
      ...
    ]
  }}
])

      Such a pipeline would not provide any predicates for the query system to use to begin the pipeline. This pipeline might benefit from being optimized to something more like:

      db.collection.aggregate([
  {$match: {$or: [{x: "SOMETHING"}, {y: "SOMETHING ELSE"}]}},
  {$facet: {
    xs: [
      {$match: {x: "SOMETHING"}},
      {$group: {...}}
    ],
    ys: [
      {$match: {y: "SOMETHING ELSE"}},
      {$unwind: "$y"},
      ...
    ]
  }}
])
      Original Description

      $facet is not smart enough to use an index. if the only stage in a pipeline is $facet, the planning system will simply default to a COLLSCAN.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Vick Mena (Inactive)
            Votes:
            9 Vote for this issue
            Watchers:
            29 Start watching this issue

              Created:
              Updated: