Re: What hint would you try?

From: Wolfgang Breitling <>
Date: Fri, 10 Jun 2011 07:33:31 -0600
Message-Id: <>

I wasn't arguing against ANSI join syntax because Oracle's adoption of it is buggy but because the optimizer as of current doesn't understand it very well and makes bad decisions as a result. If you have a problem, performance or wrong results, with a SQL written with ANSI join syntax you are well advised to try and rewrite it in Oracle syntax - and open an SR, particularly in the case of wrong results.

On 2011-06-10, at 2:52 AM, Gints Plivna wrote:

> But argument
> that something new is buggy and therefore not using it

Received on Fri Jun 10 2011 - 08:33:31 CDT

Original text of this message