Re: Slow query (only the first time)
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Wed, 18 May 2011 18:49:24 +0200
Message-ID: <ir0tal$b0u$1_at_dont-email.me>
El 18/05/2011 17:40, "Álvaro G. Vicario" escribió/wrote:
>> On May 13, 4:49 am, "Álvaro G. Vicario"
>> <alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
>>
>> MOS Bug 4169306: ANSI JOIN GIVES BAD PLAN COMPARED TO ORACLE JOIN
>>
>> WORKAROUND:
>> -----------
>> Don't use ansi joins.
>>
>> I'm sure that's not the only one, start googling...
Date: Wed, 18 May 2011 18:49:24 +0200
Message-ID: <ir0tal$b0u$1_at_dont-email.me>
El 18/05/2011 17:40, "Álvaro G. Vicario" escribió/wrote:
> El 13/05/2011 18:09, joel garry escribió/wrote:
>> On May 13, 4:49 am, "Álvaro G. Vicario"
>> <alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
>>
>> MOS Bug 4169306: ANSI JOIN GIVES BAD PLAN COMPARED TO ORACLE JOIN
>>
>> WORKAROUND:
>> -----------
>> Don't use ansi joins.
>>
>> I'm sure that's not the only one, start googling...
Good point. Natural joins were introduced in Oracle 9 and Tom hates them.
I've made a simple test (ansi vs oracle) and both execution plans have absolutely nothing in common. Curiously, the second one does not display figures (rows, bytes and cost are empty... :-?) From my test, it looks like the ANSI join does not use a single index: it's all TABLE ACCESS FULL :-!
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://borrame.com -- Mi web de humor satinado: http://www.demogracia.com --Received on Wed May 18 2011 - 11:49:24 CDT