[teiid-issues] [JBoss JIRA] (TEIID-4084) Improve with clause performance via inlining

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4084:
----------------------------------
    Component/s: Grammar
    Description: We should inline a with clause item that is only referenced a single time with a hint to prevent this behavior.  Scalar with clauses could still be inlined multiple times.   (was: There are couple of things we can do here.  The first would just be to inline a with clause item that is only referenced a single time (we may need to allow a hint to prevent this behavior).  The other would be to generally allow more iterative processing - currently all results need to built into the common table before it can be accessed, but that should be able to be relaxed and done on demand.)
        Summary: Improve with clause performance via inlining  (was: Improve with clause performance)


Splitting into two jiras.

> Improve with clause performance via inlining
> --------------------------------------------
>
>                 Key: TEIID-4084
>                 URL: https://issues.jboss.org/browse/TEIID-4084
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Grammar, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> We should inline a with clause item that is only referenced a single time with a hint to prevent this behavior.  Scalar with clauses could still be inlined multiple times. 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)