[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2249: --------------------------------------- There is current logic that unconditionally allows for the pushdown of dependent joins. In essence the tuplebuffer(s) backing the independent side are made available at the translator level to be dealt with via customization - there is no built-in handling at the translator level. To provide a solution around temp tables we have to consider: * when should the dependent join pushdown occur (based upon the raw number of input keys, the potential number of source queries to spawn, etc.) * what handling is needed at the translator level, assuming the conditional pushdown logic is sufficient then the only handling we would expect is then need to create a temporary table. If the conditional logic is not sufficient then it seems like the translator level would need most of the engine strategy / logic such as splitting across predicates/queries. * additional concerns not yet specified, such as what schema should be used, the direction of the join (if indexes would need to be added to the temporary table), etc. -- 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