Re: OPTIMIZER_MODE ???

hi,

in SQL-Plus you can use:

alter session set optimizer_goal = rule;

Tested on Oracle 7.3.2 and 7.3.3 and older releases.

Kind regards,

Toni  

In article <69u3e9$e08_at_mtinsc02.worldnet.att.net>, "InDfw" <in_dfw_at_hotmail.com> wrote:

> Nabil,
>
> The optimizer mode can be seen by selecting from v$parameter where name =
> 'optimizer_mode'.
> The default is "CHOOSE". In the "CHOOSE" mode, Oracle will use the
> cost-based optimzer
> if the tables have been analyzed. If the tables have not been analyzed,
> then the rule-based
> optimzer is used. The rule-based optimizer will be used if the hint /*
> RULE */ is placed in the
> SQL statement, and also if the optimizer mode is set to "RULE". You can
> analyze the
> tables by performing the statement; analyze table xyz compute statistics.
> One way to
> see if a table has been analyzed is to see if the column num_rows has been
> populated in
> dba_tables.
>
> Hope this helps...
>
> Phil Cook
> Certified Oracle DBA
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  | Please remove            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.