[teiid-issues] [JBoss JIRA] (TEIID-3009) perform projection minimization on with commands

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12984056#comment-12984056 ] 

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)