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
CAR Domain/s:
None

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

For now, we include all fields for sampling estimation used in join ordering & single table access path planning, but we actually could be smarter by extracting relevant fields to use as a projection. This is tricky in cases where we have multiple canonical queries per namespace, for instance.

depends on

SERVER-134526 extractTopLevelFieldsFromMatchExpression is incorrect when the MatchExpression references $$ROOT

In Code Review

SERVER-134303 Apply requested field projection when loading persistent samples

In Progress

is related to

SERVER-130958 Investigate if adding a projection to the samples collection query degrades perf too much

Needs Scheduling

SERVER-112198 Improve NDVs computation speed

Open

related to

SERVER-130958 Investigate if adding a projection to the samples collection query degrades perf too much

Needs Scheduling

Assignee:: Henri Nikku
Reporter:: Alya Berciu
Participants:: Alya Berciu, Henri Nikku
Votes:: 0 Vote for this issue
Watchers:: 7 Start watching this issue

Created:: Oct 09 2025 05:39:40 PM UTC
Updated:: Sep 08 2026 11:00:51 AM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates

PagerDuty