Re: Why is this query slow?
Date: Sat, 13 Mar 2010 07:18:22 +0100
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
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.
Maxim Received on Sat Mar 13 2010 - 00:18:22 CST