Re: RBO vs CBO

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 17 Sep 2002 15:48:59 GMT
Message-ID: <3D874EB5.3033E13E@exesolutions.com>

Jennifer wrote:

> Is it true that, even if the OPTIMIZER_MODE is set to RULE, that once
> ANALYZE is performed on a table, the Cost Based Optimizer is invoked
> instead?
>
> If this is not the case, how can I switch to the cost-based optimizer while
> keeping the OPTIMIZER_MODE = RULE in the "init.ora" file?
>
> --
> _________________________________
> Jennifer Champagne
> Decision Academic Graphics Inc.
> Tel: (613) 233-2365 x226
> Email: Jennifer.Champagne_at_DagSoft.com

Open the init.ora and change RULE to CHOOSE.

Restart Oracle

But don't use ANALYZE. Use DBMS_STATS.

Daniel Morgan Received on Tue Sep 17 2002 - 10:48:59 CDT