Re: Statistics and optimizer

On Fri, 4 May 2001, postbus_at_sybrandb.demon.nl wrote:

> First of all: could you please refrain from posting in
> HTML. Many newsreaders can not deal with it.

And it isn't the standard way of communicating in these forums.

> IIRC: If init.ora optimizer_goal

I believe this is optimizer_mode.

> = first_rows or all_rows cost based will be used, whether
> statistics exist or not. If no statistics exist, they will be
> estimated

Yes.

> If init.ora parameter optimizer_goal = choose if any of the
> tables involved *has* statistics, CBO will be used, if *none*
> has statistics, RBO will be used.

Yes.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.