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).