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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
