Re: Different syntax for LEFT JOIN

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 25 Nov 2004 14:50:16 +0100
Message-ID: <co23jn$hkl$1@news1.zwoll1.ov.home.nl>

Ruslan Kogan wrote:
> is there a preferred standard to use for oracle?
>
> Do queries that are written using ANSI run faster?
>
> Which is the newer standard?
>
> Thank you!!!

The ANSI standard is newer as far as Oracle is concerned. I would use the "old" Oracle ways (outer joins) if possible, as there are too many bugs with the ANSI syntax to my liking. I have hit two.

Cannot comment on performance; have not tested that.

-- 

Regards,
Frank van Bortel

Received on Thu Nov 25 2004 - 07:50:16 CST