Re: SOLVED?: Oracle interprets ANSI Inner Join as an Outer Join?
Date: Thu, 24 Sep 2009 08:40:10 -0500 (CDT)
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.
> 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.