Optimizer tuning parameter not working?

From: Mohammed Shakir <mshakir08816_at_yahoo.com>
Date: Mon, 25 Nov 2002 07:14:47 -0800
Message-ID: <F001.0050AB68.20021125071447@fatcity.com>

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

Received on Mon Nov 25 2002 - 09:14:47 CST