Why is this query slow?

#11

On 12.03.2010 23:29, The Boss wrote:

Quote:

Maxim Demenko wrote:
On 12.03.2010 14:46, Charles Hooper wrote:
On Mar 12, 5:34 am, vsevolod afanassiev
vsevolod.afanass... (AT) gmail (DOT) 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

#12

Op 13-3-2010 7:18, Maxim Demenko schreef:

Quote:

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 (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Why is this query slow?

comp.databases.oracle.server comp.databases.oracle.server

Re: Why is this query slow? - 03-13-2010 , 01:18 AM

Re: Why is this query slow? - 03-13-2010 , 04:55 AM