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: HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3

Re: HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3

From: Mark Vandenbroeck <mvandenb_at_nospam.be.oracle.com>
Date: 1997/10/27
Message-ID: <3454AEFB.2BF4@nospam.be.oracle.com>#1/1

Pedro de Souza Rodrigues Filho wrote:
> ...
> I discovered in an old manual that hints are valid just in
> optimizer_mode = cost, but when I try startup the database with this
> option in the init.ora, I receive a message saying this option "cost"
> is invalid. The default value for this parameter is "cost", but in the
> SQL*DBA, the option shows "choose" mode.
> By the way, I've contact Oracle Local support, but until
> now..................
> If one of you could help me I will be so pleased and
> thankfull.
> Thanks in advance.

The best way to enable the cost-based optimizer, is to compute statistics on the tables involved in your query.

ANALYZE TABLE ... COMPUTE STATISTICS Hope this helps,

Mark

-- 
Mark Vandenbroeck
Customer Support
Oracle Belgium
(remove the 'nospam' in the mailid to email me)
Received on Mon Oct 27 1997 - 00:00:00 CST

Original text of this message

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