Details
-
Quality Risk
-
Resolution: Done
-
Major
-
7.4
-
None
-
Medium
Description
Without a dependent join hint a composite cross source dependent join will not plan correctly unless the independent side can be pushed as a single query. The root of the issue is that join planning involving more than 1 independent table does not consider the effect of potential dependent joins early enough.
The workaround is to use a dependent join hint or set the cardinality of the independent tables small enough to trigger the proper dependent join.