Details
-
Enhancement
-
Resolution: Done
-
Critical
-
9.2
-
None
Description
Clarify in the documentation when the MAKEDEP temp table push down will be performed. It was tested and confirmed that by changing MaxInCriteriaSize to 1 and MaxDependentPredicates to 1 could force the temp table pushdown. So it would appear that when the number of independent values exceeds MaxInCriteriaSize*MaxDependentPredicates this would be performed (when Enabled Dependent Joins is true).
So, on page 832 (pdf of 9.1)
" .. then multiple dependent queries will be issued in parallel".
May want to rephrase to say if "Enabled Dependent Joins" is true, that pushed down to temp table will occur, other wise, multiple dependent queries will be issued in parallel.