Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
If a semijoin optimization is created on tables which have PK-FK relationship on join keys(e.g. customer-order ) then the reduction will not take place.
Remove the optimization in such cases.