Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Duplicate
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
Size Category:
TBD
CAR Domain/s:
None

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

It was disabled in ~~SERVER-104102~~, but it makes sense to enable it for the tests that test CBR, as it allows more plans to be generated.

At the same time, having AND_SORTED plans prevents most plan_stability tests from running with indexBasedCE, due to ~~SERVER-108505~~

duplicates

SERVER-108593 Run the plan_stability tests with internalQueryPlannerEnableSortIntersection

Needs Scheduling

is related to

SERVER-104102 Disable AND_SORTED index intersection plans in plan enumeration

Closed

SERVER-108505 indexBasedCE: unable to estimate AND_SORTED nodes with cardinalityEstimate > 0

Closed

Assignee:: Unassigned
Reporter:: Philip Stoev
Participants:: Philip Stoev
Votes:: 0 Vote for this issue
Watchers:: 1 Start watching this issue

Created:: Aug 04 2025 01:05:05 PM UTC
Updated:: Aug 16 2025 04:56:13 PM UTC
Resolved:: Aug 16 2025 04:56:13 PM UTC