[ https://issues.jboss.org/browse/TEIID-3530?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3530: --------------------------------------- Made the initial commit. This added an optional JDBC parameter to control whether dependent join values are bind values or not. It will default to false for oracle, but otherwise will be true. Although in testing it did not appear that newer versions of oracle, such as 12, had a problem with large prepared statements. Removed the dependentJoinPushdownThreshold and instead looked at the additional processing that could be performed. If there is significant post-processing then even without a hint, we'll fully push the dependent join. We will need to expand the hint syntax to also prevent this from happening. Also the dependent criteria processor will not use the key only temp table method for simple/small dependent joins. The tuning for that seemed fairly consistent for oracle and sql server sources. -- This message was sent by Atlassian JIRA (v6.3.15#6346)