Re: RBO changes plan from 8i to 9i

Hi Boris

I understand the plan is very similar.

But what is the explanation for that?

RBO stopped having new features in Oracle 7 or 8?
RBO are not affected by init.ora parameters AFIAK

One would expect when using RBO the plans stay the same. Well I was until I
started to migrate this app....


Cheers

Alex



On 7/12/06, Boris Dali <boris_dali@xxxxxxxx> wrote: 

Two plans given in your example looks very much the
same to me, aside from the "table prefetching" bit of
9i

Thanks,
Boris Dali.




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Other related posts: