[teiid-issues] [JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

[Debbie Steigner (JIRA)]

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

Debbie Steigner commented on TEIID-2249:
----------------------------------------

Response to Steve from Nelson :

Please pass this information to Steven.


Below is exactly how I would expect it to work. The reason is we can do aggregation at source instead of in Teiid to reduce the volume of data being transferred across the wire and performance reason too.


"The other possibility is that he means the entirety of the independent/driving side of the join would be shipped to form the temporary table such that the complete results are read by Teiid instead of a secondary in-Teiid join being performed." 
 
Nelson
                
> Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2249
>                 URL: https://issues.jboss.org/browse/TEIID-2249
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 8.4.1
>
>
> Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead.
> One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server.

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