Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3
Kendall Willets (TV DBA) wrote:
>
> 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.
Try this in your init.ora:
optimizer_mode = choose
-- Kelly Young Database Administrator Maricopa Community Colleges young_at_maricopa.eduReceived on Mon Oct 27 1997 - 00:00:00 CST