[ https://issues.jboss.org/browse/TEIID-2902?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2902: --------------------------------------- So what you are asking for is a grace style join that works incrementally against sorted sublists. I reworded the issue as it is generally not correct to think of this as pushing the limit as pushing the limit below an inner join could result in less results than desired. Limit pushing over joins is done in the case of cross joins and on the left side of a left outer join. Also if the enhanced sort merge join is used and there is a disparity in the sizes of the two sides, then only the smaller side will be fully fetched. The other side will be processed incrementally. So there are several cases already when processing is more like what you want. -- 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