RE: Optimizer Mode cost How to do this ?

I think the reason that you don't have a optimizer_mode=COST yet so that in one database, you have a choice to use both RULE and CHOOSE.

For a schema, you may decide that RULE based is a better choice, and for another one, you may want to use CHOOSE based.

Winnie

"Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> on 08/21/2000 01:49:00 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: 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).

--
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.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