Re: SOLVED?: Oracle interprets ANSI Inner Join as an Outer Join?

From: Rich Jesse <>
Date: Thu, 24 Sep 2009 08:40:10 -0500 (CDT)
Message-ID: <>

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.

Received on Thu Sep 24 2009 - 08:40:10 CDT

Original text of this message