Re: Slow SQL, too many logical reads ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 4 May 2007 19:07:14 +0100
Message-ID: <P5KdnTnAiLIq66bbnZ2dnUVZ8silnZ2d@bt.com>

"Peter" <peternybor_at_gmail.com> wrote in message
news:1178030834.571357.275300_at_e65g2000hsc.googlegroups.com...

8 - access("IA"."IA_IACT2"="AA"."AA__ICODE" AND
"IA"."IA_REASON"='#EPM#Int2Int'

AND
("IA"."IA_SEQUE"=0 OR "IA"."IA_SEQUE"=1 OR
"IA"."IA_SEQUE"=2 OR "IA"."IA_SEQUE"=3

OR

"IA"."IA_SEQUE"=4 OR "IA"."IA_SEQUE"=5 OR
"IA"."IA_SEQUE"=6 OR "IA"."IA_SEQUE"=9

OR

"IA"."IA_SEQUE"=10 OR "IA"."IA_SEQUE"=11 OR
"IA"."IA_SEQUE"=17)

AND
"IA"."IA__DELETED"='N')
Peter,

Can you tell us the definition of the four-column index - the column order may have some bearing on the resource usage.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Fri May 04 2007 - 13:07:14 CDT