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
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