Loading...

XML

Word

Printable

JSON

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

Backwards Compatibility:
Fully Compatible
Sprint:
QO 2023-12-11, QO 2023-12-25
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

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

This should include:

a query knob
logic to identify when to skip rewrites/ pick the appropriate phases/rewrites
an alternate rewrite to replace FilterSubstitute where we don't generate SargableNodes
avoid splitting filter nodes if we are not generating sargable nodes

depends on

SERVER-81973 Implement generic logic to configure which phases and rewrites to run for input query

Closed

is depended on by

SERVER-83442 Reorder predicates in a Filter node based on selectivity

Closed

SERVER-83456 Skip Filter->Sargable rewrite for collscan plans

Closed

SERVER-83927 Investigate/fix memory error with opt off and 1000 FilterNodes

Closed

Assignee:: Alya Berciu
Reporter:: Alya Berciu
Participants:: Alya Berciu, Githook User
Votes:: 0 Vote for this issue
Watchers:: 4 Start watching this issue

Created:: Dec 04 2023 11:04:43 AM UTC
Updated:: Dec 14 2023 09:48:09 AM UTC
Resolved:: Dec 14 2023 09:48:08 AM UTC
Confidence Status Last Update:: 04/Dec/23 11:47 AM