Details
-
Feature Request
-
Resolution: Done
-
Major
-
7.4
-
Documentation (Ref Guide, User Guide, etc.)
-
Low
Description
The optional join hint currently works only in ansi joins, and then only if the table(s) are not used in where predicates forcing unnatural on clauses.
e.g. select b.* from /*+optional*/ a, b where a.x = b.x
should still allow a to be optional.