[ https://issues.jboss.org/browse/TEIID-5421?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-5421 at 7/17/18 2:04 PM: ---------------------------------------------------------------- I'm seeing two issues. The first is that TEIID-5017 allows for some joins to be processed sub-optimally - the avoidance of buffering is causing more work by searching an index that is too large. A follow on issue that is probably not directly related is that running a reproducer for the case described by TEIID-5417 repeatedly shows that as more of the materialization is pushed out of the heap memory space performance significantly drops. was (Author: shawkins): I'm seeing two related issues. The first is that TEIID-5017 allows for some joins to be processed sub-optimally - the avoidance of buffering is causing more work by searching an index that is too large. A follow on issue that is probably not directly related is that running a reproducer for the case described by TEIID-5417 repeatedly shows that as more of the materialization is pushed out of the heap memory space performance significantly drops. -- This message was sent by Atlassian JIRA (v7.5.0#75005)