Oracle ANSI join vs traditional join which performs better
In our application we are using Oracle join syntax ( + ) for outer joins. I see recommendation to use ANSI join instead of conventional one. But the advantages are only better readability and full outer join capability. What I want to know is, will there be any difference in performance? We have existing queries using ( + ), and our DB is on 11g so we want to make a decision of rewriting it with ANSI joins if there will be any improvement in the performance.
Kindly Advise.