Re: RBO changes plan from 8i to 9i

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: "Boris Dali" <boris_dali@xxxxxxxx>
  • Date: Wed, 12 Jul 2006 21:00:35 +0200

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006