[teiid-issues] [JBoss JIRA] (TEIID-2558) Add translator support for dependent join pushdown

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12789513#comment-12789513 ] 

Steven Hawkins commented on TEIID-2558:
---------------------------------------

> May be hybrid approach based on cardinality of push size? May be JDBC driver is contributing to performance of creation of table?

Compared to the overall join the creation of a temp table or array/struct types is not that expensive - however for the particular database, such as Oracle, it's really considered an anti-pattern to issue DDL on an ad hoc basis.  This is a general problem for any databases that has similar restrictions (only global temp tables, forcing commit when issuing ddl, etc.).

So for Oracle what I'm really saying is that for reasonably sized single column string or number based join the array method using an existing system array type is the only method that works without issuing DDL.
                
> Add translator support for dependent join pushdown
> --------------------------------------------------
>
>                 Key: TEIID-2558
>                 URL: https://issues.jboss.org/browse/TEIID-2558
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Connector API
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> JDBC translators should offer built-in support for dependent join pushdown - possibly with index creation and other options.

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