-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
QO 2023-04-17, QO 2023-05-01
-
135
Support a DNF when converting a filter to PSR: a vector of partial schema req. If we encounter a PathComposeA, convert to a vector. After conversion, place a disjunction using a new RIDUnionNode.
- depends on
-
SERVER-75587 [CQF] Handle RIDUnion for physical optimization
- Closed
-
SERVER-74101 [CQF] Update callsites of PartialSchemaRequirements to handle Disjunctions
- Closed
-
SERVER-74539 [CQF] Handle disjunction in PartialSchemaReqConversion
- Closed
-
SERVER-74540 [CQF] Handle disjunction in SargableNode in CE
- Closed
-
SERVER-70163 [CQF] Implement RIDUnionNode
- Closed
-
SERVER-70164 [CQF] Support Partial Schema Requirements in DNF form
- Closed
-
SERVER-70637 [CQF] Implement sorted merge physical node
- Closed
-
SERVER-71846 [CQF] Utility to convert a BoolExpr tree between CNF and DNF
- Closed
- is depended on by
-
SERVER-72010 [CQF] SortedMergeNode reference tracker logic excludes some definitions from children
- Closed
-
SERVER-69351 [CQF] Use a union plan avoid fetching non-null indexed fields
- Closed
- is related to
-
SERVER-68488 Estimate FilterNode with mixed sargable and non-sargable AND/OR children
- Closed