[
https://issues.jboss.org/browse/TEIID-3237?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-3237.
-----------------------------------
Resolution: Done
Modified the join region logic to not penalize joins with unknown costs with predicates
and to check if criteria is marked as optional to build a better tree in certain
situations.
Prevent processing cross joins with unknown cardinalities
---------------------------------------------------------
Key: TEIID-3237
URL:
https://issues.jboss.org/browse/TEIID-3237
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
The optimizer will select plans with cross joins (particularly with a parent dependent
join) when the join is to be processed in Teiid and the cardinality of both sides of the
join are unknown.
We should prefer non cross join plans in these scenarios.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)