[teiid-issues] [JBoss JIRA] (TEIID-2481) common table (with) push down improvements

Steven Hawkins created TEIID-2481: ------------------------------------- Summary: common table (with) push down improvements Key: TEIID-2481 URL: https://issues.jboss.org/browse/TEIID-2481 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins The general strategy for with pushdown should better handle: - a with clause that can be pushed against a source that does not support common table. If a single reference or some other sufficient condition is met then we should just inline the pushdown rather than inhibiting the whole query from pushing down. - even if a source supports with pushdown, it may be more performant in some circumstances to inline the common table reference (such as only a single reference). This is complicated slightly by subqueries. - alternatively in some situations even if a with clause can be pushed, it may be better to not perform the pushdown (this may need to be hint driven). -- 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