Generally you'll changes in the 'cost' figure when
playing with Optimizer_index_cost_adj. If you change
the permutations figure, you'd probably need to look
at 10053 to see the differences going on...
Oracle pretty rarely chooses a cartesian product
(between tables of any siginificant size that is), so
maybe you might want to look at the sql and/or the
indexes on the schema before looking for a solution in
the optimizer parms..
hth
connor
- Mohammed Shakir <mshakir08816_at_yahoo.com> wrote: >
I changed the optimizer_search_limit value to 1 in
> init.ora to minimize
> the cartesian product in my execution plans. But I
> do not see any
> change in my execution plans. Am I missing
> something?
>
> I modified init.ora and bounced the database. I have
> also tried to run
> the query after manually set it in my sql session
> without any change in
> results. I tried it on NT/Oracle 8.1.7.4.1
>
> I noticed that my execution plans do not change for
> the following
> tuning parameters either.
>
> 1. Optimizer_index_cost_adj=50
> 2. Optimizer_max_permutations=70000
>
> =====
> Mohammed Shakir
> CompuSoft, Inc.
> 11 Heather Way
> East Brunswick, NJ 08816-2825
> (732) 672-0464 (Cell)
> (732) 257-6001 (Home)
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus – Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mohammed Shakir
> INET: mshakir08816_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Nov 25 2002 - 10:54:26 CST
