RE: Analayze

Ed,
Yes you are right i have deleted statistics for all those tables and now optimizer use rule base and working fine now. Thanks for your help
have a good weekend

-----Original Message-----
From: Shevtsov, Eduard [mailto:EShevtsov_at_flagship.ru] Sent: Thursday, 5 October 2000 21:03
To: Multiple recipients of list ORACLE-L Subject: RE: Analayze

Hi Hamid

If there is at least one analyzed table in your query/dml and optimizer_mode = choose, oracle use cost based optimizer. But be very careful, it's not a good practice to use some tables with statistics and some without it. So you have two choices: to analyze all of your tables or do not analyze tables at all. The last choice is appropriated for old applications which have been tunned for RBO.

Please, correct me if I'm wrong

Ed

>
>
> Hi,
>
> I have still some few problems affected from ANALYZE result
> and don't know
> if we have 3 tables EX: T1,T2,T3 and run ANALYZE on just T1
> then if SQL
> statment using these 3 tables which optimizer is going to be
> used?? CBO or
> RBO or both!!!!!!
>
>
> Hamid Alavi
> DDI 3610148
> FAX 3610102
> 111 Franklin RD Freemans Bay Auckland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: EShevtsov_at_flagship.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).