[teiid-issues] [JBoss JIRA] (TEIID-5417) Performance degradation with large in predicate against temp table

Steven Hawkins (JIRA) issues at jboss.org
Fri Jul 13 13:53:00 EDT 2018


Steven Hawkins created TEIID-5417:
-------------------------------------

             Summary: Performance degradation with large in predicate against temp table
                 Key: TEIID-5417
                 URL: https://issues.jboss.org/browse/TEIID-5417
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 11.1, 11.0.1, 10.3.3


Dependent joins producing a large in predicate will do a linear search over the predicate.  The predicate should be marked as all constants and dealt with as a set instead.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)


More information about the teiid-issues mailing list