[teiid-issues] [JBoss JIRA] Resolved: (TEIID-211) subquery optimization

Tue Nov 16 16:34:15 EST 2010

     [ https://jira.jboss.org/browse/TEIID-211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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