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