Re: Cost Based Optimizer Question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/05/24
Message-ID: <dp2oiss3q5l9imlpmoktbdqt7oljp8hi0p@4ax.com>#1/1

You can use the RULE hint to force the use of the rule-based optimizer regardless of the presence of statistics:

select /*+rule */ x,y,z
from your_table;

I believe you can also set OPTIMIZER_MODE=RULE in your init parameter file. It's with the CHOOSE setting that you run into the issue of statistics causing a switch to the cost-based optimizer.

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Tue, 23 May 2000 16:52:21 -0500, ttrivedi <ttrivedi_at_deja.com> wrote:

>I have a quick question . Is it true that if the statistics for even a
>SINGLE table is available
>then the cost based optimizer WILL be used irrespective of what is
>specified ?
>
>Like if I do
>analyze table one compute statistics
>then I cannot use the rule based optimizer any more ?
Received on Wed May 24 2000 - 00:00:00 CDT