-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Fully Compatible
-
None
-
None
-
None
-
None
-
None
-
None
-
None
For a join R.a = S.a and a single table predicate R.a = 5, we can infer the predicate S.a = 5 to improve the access path on S.
To support this, we need to incorporate these predicates into the JoinGraph and think through the implications on cardinality estimation.
- related to
-
SERVER-120819 Query hits tassert due to inferred self-edges
-
- Closed
-
-
SERVER-127575 Handle the case of identical predicates in the same equivalence class
-
- Needs Scheduling
-