"Ryan" <rgaffuri_at_cox.net> wrote in message
news:Kd3bb.337$0Z5.118_at_lakeread03...
> one little addendum. if you go to ixora.com.au(great site) you will see
> several scripts that use 'ORDERED', however, he is hitting the data
> dictionary. Until version 10, the system tablespace is still using the
RBO.
>
<pedant>
you mean the SYS schema not the SYSTEM tablespace
</pedant>
This is true except for a very few DD views that themselves contain hints,
since hints force the use of the CBO (except for RULE ...).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Sep 22 2003 - 03:46:55 CDT
