Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization
Confidence Status:
None
Work Order:
3

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

We execute counts over views as aggregations, but there is no reason that all count commands couldn't internally use the agg path.

depends on

SERVER-57518 16% performance loss switching from Count to CountDocuments

Backlog

related to

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

Backlog

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: David Storch
Participants:: [DO NOT USE] Backlog - Query Optimization, Andy Schwerin, David Storch
Votes:: 1 Vote for this issue
Watchers:: 8 Start watching this issue

Created:: Aug 31 2016 04:14:08 PM UTC
Updated:: Apr 02 2025 12:15:59 PM UTC