Loading...

XML

Word

Printable

JSON

Type: New Feature
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 7.3.0-rc0
Affects Version/s: None
Component/s: None
Labels:
None

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Confidence Status:
None
Work Order:
3

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

For sargable nodes, iterate over residual requirements, and lower using “lowerPartialSchemaRequirement”
This generates filters and eval nodes.
Insert a physical scan node using scan params.

Basically copy and refactor segment of handler for SargableNode in implementers.cpp with target = Complete

is depended on by

SERVER-80732 [CQF] Improve SamplingPlanExtractor to produce optimal physical plans

Closed

is duplicated by

SERVER-80732 [CQF] Improve SamplingPlanExtractor to produce optimal physical plans

Closed

related to

SERVER-84713 Ensure the child of a SargableNode is always a ScanNode after substitution phase

Closed

Assignee:: Chi-I Huang
Reporter:: Svilen Mihaylov (Inactive)
Participants:: Chi-I Huang, Githook User, Svilen Mihaylov
Votes:: 0 Vote for this issue
Watchers:: 5 Start watching this issue

Created:: Sep 29 2023 08:05:59 PM UTC
Updated:: Jan 18 2024 08:56:31 PM UTC
Resolved:: Jan 16 2024 08:30:36 PM UTC
Confidence Status Last Update:: 16/Nov/23 8:04 PM