-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
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-87741 Make distinct command on views use DISTINCT_SCAN
- Backlog
-
SERVER-3141 distinct needs to have a way to output to a cursor for large result sets
- Closed