You're right about the performance - they (the ones before I got here) tried
to run the stats and use choose and the performance was terrible. Now it is
not an option to use CBO. One of my tasks is to set up an environment and
take it to CBO, but this is not the immediate priority.
-----Original Message-----
Sent: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
John,
First question, how do you know that your application is rule based?
Most
application scan be switched to cost optimization with no changes, although
I
will admit performance sometimes goes south. I prefer to set the database
to
'choose' mode which allows the best of both worlds.
Dick Goulet
____________________Reply Separator____________________
Author: Shaw John-P55297 <[EMAIL PROTECTED]>
Date: 3/14/2002 9:33 AM
I am new to the world of partitioning. 816 on W2K. In a white paper on
metalink "How to Implement Partitioning in Oracle Versions 8 and 8i " it
states that "The RULE-based optimizer does not take the partitioning of
tables and
indexes into account."
My question is - if your application is still rule based is there any value
to partitioning? Some of the tables are over 30 million rows and 5G. If my
understanding is correct I wouldn't see any performance improvement but
would make maintenance simpler.
--
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:
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: 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).
