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

Steven Hawkins (JIRA) jira-events at lists.jboss.org
Wed Jan 2 10:23:08 EST 2013


Steven Hawkins created TEIID-2338:
-------------------------------------

             Summary: 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


More information about the teiid-issues mailing list