Re: What hint would you try?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 10 Jun 2011 07:33:31 -0600
Message-Id: <8F17A9FD-0293-48DE-9E95-C74A89DB51F0_at_centrexcc.com>
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.
Date: Fri, 10 Jun 2011 07:33:31 -0600
Message-Id: <8F17A9FD-0293-48DE-9E95-C74A89DB51F0_at_centrexcc.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 10 2011 - 08:33:31 CDT