[
https://issues.jboss.org/browse/TEIID-3009?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3009:
---------------------------------------
A rough outline of the approach will be to check the plan for CTEs used in views. If they
exist, we'll have to create a temporary initial plan form and run rule assign output
elements, then we can analyze the result to cull the CTE projected symbols.
perform projection minimization on with commands
------------------------------------------------
Key: TEIID-3009
URL:
https://issues.jboss.org/browse/TEIID-3009
Project: Teiid
Issue Type: Sub-task
Security Level: Public(Everyone can see)
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.9
We currently treat the with clause as the creation of a temporary table at a query scope,
but we can do projection minimization based upon the referenced columns. This is somewhat
tricky with the current planning logic as we must first plan the with clause to determine
if it's eligible for pushdown to then plan the main command.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)