Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is Richard Niemiec Right

Re: Is Richard Niemiec Right

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 22 Sep 2003 04:53:36 -0700
Message-ID: <1e8276d6.0309220353.60269599@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US