RE: Optimizer Mode cost How to do this ?

I think you only have 4 choices for optimizer_mode CHOOSE
FIRST_ROWS
ALL_ROWS
RULE I still do not understand why there in not a optimizer_mode=cost option. If you analyze your tables and optimizer_mode=choose CBO will be chosen.

Rick

> -----Original Message-----
> From: Khedr, Waleed [SMTP:Waleed.Khedr_at_FMR.COM]
> Sent: Monday, August 21, 2000 2:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Optimizer Mode cost How to do this ?
>
> You should open Oracle documentation.
>
> -----Original Message-----
> Sent: Saturday, August 19, 2000 8:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear List,
> I want to put my database in cost mode when I try to
> put
> optimizer_mode = cost
> in initsid.ora it is giving error at database startup
> what should I do?Thanks in advance.
> Regards,
> Rajanish Joshi
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Rajanish Joshi
> INET: dbaoracle2000_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Aug 21 2000 - 14:37:15 CDT