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.