Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OPTIMIZER_MODE ???
This is a 'bug' in Oracle documentation -- 'COST' is not a valid value. The reality, as you have found out, is this:
RULE = rule-based optimizer
CHOOSE = cost-based optimizer
Pei
Nabil Courdy <moab_at_emirates.net.ae> wrote in article
<01bd2438$35c7d8a0$4b0ee5c3_at_msdusr>...
>
> I am unable to set OPTIMIZER_MODE = COST under
> 7.3 on NT 4.0. It only accepts RULE or CHOOSE.
> I read somewhere in the Advanced Tuning book that is
> is best to set it at either COST or RULE. Any idea?
>
> Nabil Courdy
> moab_at_emirates.net.ae
> ==================
> --
>
>
Received on Mon Jan 19 1998 - 00:00:00 CST