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