[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

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: Van Halbert Fix For: 8.5 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.