| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitioning question
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 <P55297_at_motorola.com> 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: P55297_at_motorola.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).
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).
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 Thu Mar 14 2002 - 13:03:32 CST
 |
 |