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

XML

Word

Printable

Details

Type: Improvement
Status: Open
Priority: Major - P3
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: Backlog
Component/s: Querying
Labels:
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

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

Closed

is related to

SERVER-25184 Add a $distinct aggregation stage

Open

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

Open

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:: Oct 13 2021 07:58:00 PM UTC