[
https://jira.jboss.org/browse/TEIID-211?page=com.atlassian.jira.plugin.sy...
]
Steven Hawkins resolved TEIID-211.
----------------------------------
Resolution: Done
Added rewrite handling for where subqueries that are correlated against unique values from
the outer query. Also added cost based semi and anti semi join handling for non-pushed
subqueries.
TODO:
makedep hint on a subquery
rewrite select scalar subqueries
rewrite subqueries in the on clause
better null detection for not conditions
better unique detection (right now we're restricted to simple queries and and key
columns)
subquery optimization
---------------------
Key: TEIID-211
URL:
https://jira.jboss.org/browse/TEIID-211
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.3
Implement rewriter (and planner) optimizations for subqueries based upon semi and anti
semi join capabilities.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira