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

Make the distinct command always execute as an aggregation pipeline

    XMLWordPrintable

Details

    • Improvement
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Querying
    • None

    Description

      We execute distinct over views as aggregations, but there is no reason that all distinct commands couldn't internally use the agg path.

      As part of this work, we need to allow the aggregation system to make use of the DISTINCT_SCAN fast path for aggregations that are logically distinct operations.

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-27915 Make $group with $addToSet accumulator use DISTINCT_SCAN when applicable

          • Major - P3 - Major loss of function.
          • Backlog
          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-25184 Add a $distinct aggregation stage

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-25898 Make the count command always execute as an aggregation pipeline

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

          New Feature - A new feature of the product, which has yet to be developed. SERVER-3141 distinct needs to have a way to output to a cursor for large result sets

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

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              david.storch@mongodb.com David Storch
              Votes:
              4 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated: