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

From: Kendall Willets (TV DBA) <willetsk_at_wellsfargo.com>
Date: 1997/10/27
Message-ID: <3454E9EF.2526@wellsfargo.com>#1/1

Mark Vandenbroeck wrote:
>
> 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

Try one of the following:

add the hint FIRST_ROWS or ALL_ROWS to your statements alter session set optimizer_goal = first_rows (or all_rows) set the init.ora optimizer_mode = <same as above>

We currently have optimizer_mode = rule, but use hints to turn on the CB optimizer. Received on Mon Oct 27 1997 - 00:00:00 CST