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
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

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 depended on by

SERVER-101576 Improve cluster distinct command to skip aggregating results when targeting a single shard

Blocked

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

SERVER-99639 Avoid deduping DISTINCT_SCAN output in distinct()

Needs Scheduling

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 is related to, 2 related to)

Assignee:: Unassigned
Reporter:: David Storch
Participants:: Andy Schwerin, David Golden, David Storch
Votes:: 5 Vote for this issue
Watchers:: 16 Start watching this issue

Created:: Aug 31 2016 04:16:23 PM UTC
Updated:: Mar 14 2025 03:22:25 PM UTC

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates