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
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