Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OPTIMIZER_MODE ???

Re: OPTIMIZER_MODE ???

From: Pei L. Ku <pku_at_gte.net>
Date: 1998/01/19
Message-ID: <69urt0$ms7$1@gte2.gte.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US