Re: SOLVED?: Oracle interprets ANSI Inner Join as an Outer Join?
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 24 Sep 2009 08:40:10 -0500 (CDT)
Message-ID: <018945bea4529e722d30c9545791e205.squirrel_at_society.servebeer.com>
I had some performance issues with ANSI compared to it's Oracle equivalent in 9iR2, but nothing I can recall so far in the 3 years I've been using (or stuck with!) 10g.
Date: Thu, 24 Sep 2009 08:40:10 -0500 (CDT)
Message-ID: <018945bea4529e722d30c9545791e205.squirrel_at_society.servebeer.com>
I had some performance issues with ANSI compared to it's Oracle equivalent in 9iR2, but nothing I can recall so far in the 3 years I've been using (or stuck with!) 10g.
I do like the flexibility of being able to outer join a table that's outer joined, which isn't possible with the Oracle syntax.
Rich
> Personally I have been using ANSI much more frequently.
>
> I often neglect to do so with equijoins, but whenever an
> outer join is to be used, I use ANSI SQL.
>
> It is simpler to write, and easier to read IMO.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 24 2009 - 08:40:10 CDT