[SERVER-25899] Make the distinct command always execute as an aggregation pipeline - MongoDB Jira

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Backlog
Priority: Major - P3
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: Querying
Labels:
None

Assigned Teams:

Query Optimization

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

SERVER-27915 Make $group with $addToSet accumulator use DISTINCT_SCAN when applicable

Backlog

is related to

SERVER-25184 Add a $distinct aggregation stage

Backlog

SERVER-25898 Make the count command always execute as an aggregation pipeline

Backlog

related to

SERVER-3141 distinct needs to have a way to output to a cursor for large result sets

Closed

Activity

People

Assignee:: Backlog - Query Optimization

Reporter:: David Storch

Participants:: Andy Schwerin, Backlog - Query Optimization, David Golden, David Storch

Votes:: 4 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: Aug 31 2016 04:16:23 PM UTC

Updated:: Dec 06 2022 04:17:41 AM UTC