Allow index use for all aggregation pipeline $match and possibly $filter stages instead of just the first stage.

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Aggregation Framework
    • None
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Not sure if this is possible but, as I understand it, indexes are only used for the first $match stage of a pipeline and then a collection scan for all the others after that.

      If possible it might be beneficial to use indexes for all $match stages and possibly $filter expressions too as they themselves can be quite powerful.

            Assignee:
            Mark Agarunov (Inactive)
            Reporter:
            Andrew Harris
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: