Details
-
Feature Request
-
Resolution: Done
-
Major
-
None
-
None
Description
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.
Attachments
Issue Links
- is related to
-
TEIID-196 Support creation of temp tables on physical sources.
- Closed