Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-37304

Extend $sort+$group+$first pipeline optimization to $last

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • Query Optimization 2021-06-14, Query Optimization 2021-06-28, Query Optimization 2021-07-12, Query Optimization 2021-07-26, QO 2021-09-06, Query Optimization 2021-08-09, QO 2021-09-20, QO 2021-10-04, QO 2021-10-18, QO 2021-11-01, QO 2021-11-15, QO 2021-11-29, QO 2021-12-13, QO 2021-12-27, QO 2022-01-10, QO 2022-01-24, QO 2022-02-07, QO 2022-02-21, QO 2022-03-07, QO 2022-03-21, QO 2021-08-23, QO 2022-04-04, QO 2022-04-18, QO 2022-05-02, QO 2022-05-16, QO 2022-05-30, QO 2022-06-13, QO 2022-06-27, QO 2022-07-11

    Description

      The optimization described in SERVER-9507 can be applied to $group expressions that exclusively use $last accumulators by running the DISTINCT_SCAN in the reverse direction.

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-9507 Optimize $sort+$group+$first pipeline to avoid full index scan

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-55576 Optimize queries on time-series collections which request the most recent value

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              alya.berciu@mongodb.com Alya Berciu
              justin.seyster@mongodb.com Justin Seyster
              Votes:
              1 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: