At least now you can go with CHOOSE instead of strictly cost based. Its
a much smaller plunge, you can pick and choose which objects to try
first.
-----Original Message-----
Sent: Tuesday, January 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
I have a large app that is still running rule based, we are finally
going to take the plunge and try to start going cost based. The first
time we tried this the performance was terrible in a lot of places. Does
anyone have any good white papers or hints/tips on what to look for on
areas that might be problems or pitfalls? tia ... --- ... .... . .-..
.--. -- . .. .----. -... . . -. .--. .-. --- -... .-..
John B. Shaw
(ribit)
/
o o
( -- )
/\( , ,)/\
^^ ^^ ^^ ^^
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw John-P55297
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
