-
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
-