SQL Performance (MOSC)

MOSC Banner

Oracle ANSI join vs traditional join which performs better

edited Jan 28, 2015 4:31PM in SQL Performance (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center