Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization
Confidence Status:
None
Work Order:
3

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

While distinct command may generate DISTINCT_SCAN plans, it doesn't do so in the case of views (including identity views).

is related to

SERVER-25899 Make the distinct command always execute as an aggregation pipeline

Backlog

SERVER-37715 Use DISTINCT_SCAN for $unwind-$group pipelines

Backlog

SERVER-68567 distinct command on the Time-Series collection doesn't utilize the existing index

Backlog

related to

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

Backlog

Assignee:: Unassigned
Reporter:: Denis Grebennicov
Participants:: Denis Grebennicov
Votes:: 0 Vote for this issue
Watchers:: 5 Start watching this issue

Created:: Mar 10 2024 11:57:24 AM UTC
Updated:: Jan 24 2025 10:23:41 AM UTC