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
Received on Thu Oct 05 2000 - 02:19:12 CDT