Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 mayReceived on Mon Aug 21 2000 - 15:33:27 CDT
![]() |
![]() |