Re: Why is this query slow?
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 13 Mar 2010 07:18:22 +0100
Message-ID: <4B9B2E2E.6020909_at_gmail.com>
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:
>>
Date: Sat, 13 Mar 2010 07:18:22 +0100
Message-ID: <4B9B2E2E.6020909_at_gmail.com>
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 Received on Sat Mar 13 2010 - 00:18:22 CST