Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization

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.

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-94090 Investigate using getNextBatched in distinct.cpp (& sharded version)

Open

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

SERVER-87741 Make distinct command on views use DISTINCT_SCAN

Backlog

(1 related to)

Assignee:: [DO NOT USE] Backlog - Query Optimization

Reporter:: David Storch

Participants:: [DO NOT USE] Backlog - Query Optimization, Andy Schwerin, David Golden, David Storch

Votes:: 5 Vote for this issue

Watchers:: 15 Start watching this issue

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

Updated:: Aug 27 2024 03:11:33 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates