Details
-
Feature Request
-
Resolution: Done
-
Major
-
6.0.0
-
None
-
Documentation (Ref Guide, User Guide, etc.), Release Notes, Compatibility/Configuration
-
High
Description
This is a multi-part request.
First, the system should support creation of temporary tables using a physical backing store rather than buffer manger. Given multi-pass SQL's heavy use of temp tables, buffer manager can easily be overloaded with large interim results stored in temp tables.
Second, this should be a user-configurable behavior. For example, user might be able to choose a system-level or session-level default from among:
– memory/cache
– a source represented by a connector binding
– a distinct temp source defined with it's own connection parameters (possibly another schema in the repository DB instance)
Ideally default selectoin should be override-able at temp table creation time through a DDL extension
In the case where multiple temp tables have been created on a source via connector, the query planner should recognize this and leverage pushdown to the temp store when later query passes access multiple temp tables.
Attachments
Issue Links
- relates to
-
TEIID-2249 Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
- Closed