[ https://issues.jboss.org/browse/TEIID-4084?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian JIRA (v6.4.11#64026)