"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
