Re: Why is this query slow?

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sat, 13 Mar 2010 10:55:56 +0100
Message-ID: <4b9b612c$0$22944$e4fe514c_at_news.xs4all.nl>

Op 13-3-2010 7:18, Maxim Demenko schreef:
> On 12.03.2010 23:29, The Boss wrote:
>> Maxim Demenko wrote:
>>> On 12.03.2010 14:46, Charles Hooper wrote:
>>>> On Mar 12, 5:34 am, vsevolod afanassiev
>>>> <vsevolod.afanass..._at_gmail.com> wrote:
>>>
>
>> I'm a little confused here.
>> Although the OP references 2 tables in his original query ('transactions'
>> and 'transaction'), I guess he actually only has 1 table
>> ('transactions'):
>> 1. OP stated: "Table has 11 million rows" which doesn't make much
>> sense if
>> he has 2 tables.
>> 2. The original Execution Plan only references table 'transactions', not
>> 'transaction'.
>>
>> Cheers!
>>
>
> You are correct, i've overlooked it in OP plan - there is only one table
> in place. However, all the NULL/NOT NULL logic discussed above still
> applies in that case, i think.
>
> Best regards
>
> Maxim

Except that the OP is on version 9, so 11g features do not apply.

Shakespeare Received on Sat Mar 13 2010 - 03:55:56 CST