Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Backport Requested:

v9.0, v8.3
Linked BF Score:
200
CAR Domain/s:
None

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

In some cases the sampling is insufficient to determine the proper CE of a predicate. This can be the case for highly selective predicates on large collections or simply a "bad" sample. This ticket should implement a fallback into MP in the case of a 0 estimate instead of using heuristics.

This ticket was intended as a fix to address HELP-98249 and was targeted only at 9.0

is depended on by

SERVER-133433 Add a metric tracking 0 CE bail out of join

Closed

is related to

SERVER-133442 In the case of zeroCE, do not fail CBR if we are doing join optimization

Needs Scheduling

SERVER-133405 Add a dedicated plan ranker 'reason' for zero CE fallback

Needs Scheduling

related to

SERVER-133591 cbr_shard_filter.js fails when featureFlagGetExecutorDeferredEngineChoice is off because an empty shard triggers zero-CE fallback to multiplanning

Closed

SERVER-132698 Make "prefer shorter indexes" code take presence of index bounds into account

Needs Scheduling

SERVER-114848 Improve ranking of index scans with different numbers of fields

Needs Scheduling

(1 related to)

Assignee:: Matt Olma
Reporter:: Peter Volk
Participants:: Matt Olma, Peter Volk
Votes:: 0 Vote for this issue
Watchers:: 12 Start watching this issue

Created:: Aug 12 2026 02:32:13 PM UTC
Updated:: Sep 11 2026 02:43:54 PM UTC
Resolved:: Sep 11 2026 02:43:54 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates

PagerDuty