[ https://issues.jboss.org/browse/TEIID-2139?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2139: ---------------------------------- Summary: Factor out common table expressions (was: CLONE - Factor out common table expressions) Complexity: Medium Forum Reference: https://community.jboss.org/message/742355 The request scope caching for commands was added as part of TEIID-2077, which somewhat addresses the initial issue discussed in the forum posting. The other variations to this are: 1. suppress pushdown so that multiple table accesses can be grouped 2. caching beyond the request scope - transaction/session 3. automatically convert subplans to common table expressions for reuse (somewhat related to 1), which is the thrust of this issue. The approach to 3) would likely be to start with multiple view/table access and replace the plan nodes with common table access - this would create a local temporary table, but perhaps would be better served with something more like the cached tuple source logic. 2) would need to be hint based and if based upon tuple buffers could backend into the common rs caching logic - otherwise I'd have to look at modifying the session temp table logic. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira