[ https://issues.jboss.org/browse/TEIID-2558?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2558: --------------------------------------- Compared to the overall join the creation of a temp table or array/struct types is not that expensive - however for the particular database, such as Oracle, it's really considered an anti-pattern to issue DDL on an ad hoc basis. This is a general problem for any databases that has similar restrictions (only global temp tables, forcing commit when issuing ddl, etc.). So for Oracle what I'm really saying is that for reasonably sized single column string or number based join the array method using an existing system array type is the only method that works without issuing DDL. -- 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