Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is Richard Niemiec Right
"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.
Sorry, but you're wrong. Using or not using CBO has nothing common with SYSTEM (or any other) tablespace. Even for queries accessing data dictinary your statement isn't true. Even these are using CBO, but with costs based on internal defaults and not on numbers taken from statistics.
with regards
Dusan Bolek Received on Mon Sep 22 2003 - 06:53:36 CDT