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:
 > 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

Original text of this message