Oracle-L: RE: partition tables

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 31 May 2002 06:33:24 -0800
Message-ID: <F001.00470C47.20020531063324@fatcity.com>

BigP - I agree with Dick that you will need to create your new partitioned table and copy the rows from your current table into it. Given your questions, before you charge into partitioning, carefully study the ways partitioning can increase your performance. It isn't just some magic pixie dust that simply makes everything faster. Carefully study how the table is accessed. For example, I applied partitioning to two instances. For one, the performance gain was tremendous. Queries that had taken more than 2 minutes to complete dropped to under 10 seconds. You could hear the users cheering. On another instance, there was no detectable performance gain and I ended up undoing the partitioning. Fortunately Oracle is pretty lenient in terms of letting you try the feature to make sure it will deliver performance worth the licensing fee.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 30, 2002 7:59 PM
To: Multiple recipients of list ORACLE-L

Hi All ,
We are thinking of converting one of huge table in to partition table . What is best way to achieve this ? Is there any alter table clause that can do this or I will have to export ..recreate table with partition option and then import . Also how can I mentiod that partition should have only 100000 rows . For example after each 100000 rows add another partition ? If I have 10000000 rows in the table , should I expect some performance gain out of this

Thanks ,
BigP

--

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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 Fri May 31 2002 - 09:33:24 CDT