[teiid-issues] [JBoss JIRA] (TEIID-2555) Support pushdown of entire dependent joins

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2555.
-----------------------------------

    Resolution: Done


Marking as resolved since initial testing has been performed.  Additional work such as new source hints, the creation of indexes, etc. will be handled as new issues.
                
> Support pushdown of entire dependent joins
> ------------------------------------------
>
>                 Key: TEIID-2555
>                 URL: https://issues.jboss.org/browse/TEIID-2555
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Connector API, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> If the data volume is not too large then in many circumstances pushing down the entire independent side of the join to perform the entire join at the source can enhance performance.
> This would likely be built upon TEIID-2249 to make use of a make dep hint option.  It would also likely be an expansion of the common table pushdown logic - but will require more extensive planning changes as the default logic is geared toward only the equi-join columns.  
> It has also been requested that the default preference for pushdown be based upon the estimated data width.
> There is an issue with the form of the plan as with the existing logic it would be nearly impossible to back out of the decision to perform the full pushdown (which is why a hint is initially preferable).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira