Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitioning question

RE: Partitioning question

From: Shaw John-P55297 <P55297_at_motorola.com>
Date: Thu, 14 Mar 2002 11:03:32 -0800
Message-ID: <F001.00429C2E.20020314110332@fatcity.com>


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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: dgoulet_at_vicr.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).
--

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). Received on Thu Mar 14 2002 - 13:03:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US