[teiid-issues] [JBoss JIRA] Resolved: (TEIID-150) Improve nested loop (in merge join) matching

Tue Oct 6 13:43:49 EDT 2009

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

Steven Hawkins resolved TEIID-150.
----------------------------------

    Resolution: Won't Fix

This is probably not worth the effort, since the match loop was not written for batch handling.  This would only be an issue for large nested loop joins (or match regions with lots of duplicates), which will already have poor performance.

> Improve nested loop (in merge join) matching 
> ---------------------------------------------
>
>                 Key: TEIID-150
>                 URL: https://jira.jboss.org/jira/browse/TEIID-150
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.x
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 6.3
>
>   Original Estimate: 1 day
>  Remaining Estimate: 1 day
>
> Nested loop evaluation should be based upon available blocks rather than fully iterating the inner side.  The simplest approach is to just match a single block from the left and right at a time. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira