[teiid-issues] [JBoss JIRA] (TEIID-2338) common table expression performance
[
https://issues.jboss.org/browse/TEIID-2338?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2338:
---------------------------------------
After some more thought the only case where this logic is generally applicable is with
correlated subqueries against a common table. However the work for TEIID-2339 will
largely handle that case as it will allow us to plan most subqueries as joins rather than
repeated scans. Will likely just reassess as an xml specific enhancement based upon the
existing auto-indexing logic.
common table expression performance
-----------------------------------
Key: TEIID-2338
URL: https://issues.jboss.org/browse/TEIID-2338
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Large common table expressions should be indexed based upon their usage in the query to
improve performance.
Also given that we will now back-off of bad dependent joins, we should be more optimistic
with using common tables as dependent joins (which would also reduce the need for an
index).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira