RBO vs CBO

From: Jennifer <Jennifer_at_DAG[DELETEME>
Date: Tue, 17 Sep 2002 15:25:00 GMT
Message-ID: <gPHh9.12512$V21.290128@news>

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

Received on Tue Sep 17 2002 - 10:25:00 CDT