[teiid-issues] [JBoss JIRA] (TEIID-2482) Allow the use of the enhanced join for left outer joins

Wed Apr 24 12:38:53 EDT 2013

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

Steven Hawkins resolved TEIID-2482.
-----------------------------------

    Resolution: Done

Updated the logic to support using the inner side of an outer join as an index for the outer side.  The logic for determining when to use an index was also improved so that the other side does not need fully buffered.

It is also possible if the left side is fully buffered to reverse the iteration to improve buffer utilization, but that was not yet added.

> Allow the use of the enhanced join for left outer joins
> -------------------------------------------------------
>
>                 Key: TEIID-2482
>                 URL: https://issues.jboss.org/browse/TEIID-2482
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.4
>
>
> Left equi outer joins are currently only implemented using the full sort merge join and would benefit from using the enhanced merge when the inner side is relatively small.

--
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