RE: Confuzzled on OPTIMiZER_INDEX_COST_ADJ

That, or as John pointed out, the query is not parsed at all. Much more likely in your case. To make sure the sql gets parsed, run it as "explain plan ... for ...".
Is there a histogram on part_no?

At 05:14 PM 9/17/2003 -0800, you wrote:
>if you are getting just the query then that means that the query is being
>parsed by the rule based optimizer. Is the table analyzed?
>At 04:29 PM 9/17/2003 -0800, you wrote:
>>John,
>>
>>OPTIMIZER_INDEX_CACHING is set to 0 in both databases, all other parameters
>>are also the same. We also kept OPTIMIZER_FEATURES_ENABLE at 8.1.7 in
>>both databases. I tried the 10053 trace but I'm not getting any results
>>in the trace file -- just the query?

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.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).