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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4084:
-------------------------------------

             Summary: Improve with clause performance
                 Key: TEIID-4084
                 URL: https://issues.jboss.org/browse/TEIID-4084
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 9.0


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.



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