[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Debbie Steigner edited comment on TEIID-2249 at 6/17/13 9:00 AM: ----------------------------------------------------------------- Customer RBS input: Hi Erica I had a read of the temp table documentation for Teiid 8.3 and I am unsure whether it meets our full requirement. It is a good start having the ability to create source temp table. As it stands, the temp table has to be predefined before the execution of the query and seems like have to be done in a teiid stored procedure. Our requirement, is the creation of source temp table will be done in the background by Teiid during runtime of a query and dependent join is pushed down to source to do the join locally at the source. It is basically shipping the temp data into target source for joining to improve the performance. It will be good if we can also hint the query to specify when to use this temp table join or set a threshold value if there are more than X no. Of values in IN clause switch to use this method. And potentially creating an index on the source temp table on the joining columns and also the ability to specify source system hints too. Thanks Nelson -- 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