[teiid-issues] [JBoss JIRA] (TEIID-2338) staging table performance

[ https://issues.jboss.org/browse/TEIID-2338?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2338: ---------------------------------- Summary: staging table performance (was: common table expression performance) Description: Large staging tables should be indexed based upon their usage to improve performance. Further usage analysis could limit the size of the initial staging table, but is somewhat complicated - and references can be used in dynamic sql. was: 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). Forum Reference: https://community.jboss.org/message/786894 -- 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