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)