Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query Slow in 10g, runs very fast in 8i

Re: Query Slow in 10g, runs very fast in 8i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 5 Jan 2007 18:40:59 -0000
Message-ID: <u4KdnfQnQ_RpBgPYnZ2dnUVZ8tSdnZ2d@bt.com>


"EscVector" <Junk_at_webthere.com> wrote in message news:1168010727.742769.119720_at_i15g2000cwa.googlegroups.com...
>
> Certainly look at the xplan, but I'd try the simple first.
>
> alter session set optimizer_index_cost_adj=10000;
>
> run the sql in sqlplus or add this line to the procedure.
>
> You can set it back after the procedure is complete.
>
> See what happens.
>

What's the rationale behind that suggestion ?

-- 
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 Jan 05 2007 - 12:40:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US