RE: How to speed up an update

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 5 Mar 2009 14:47:53 -0500
Message-ID: <009B2705860C443C8074914C927B0EC9_at_rsiz.com>

And see what Greg Rahn wrote recently about adding a column with a default value - if you've got the space and can allow the nologging operation that (CTAS, etc.) may well be the fastest way.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com Sent: Thursday, March 05, 2009 1:23 PM
To: oracle-l_at_freelists.org
Subject: How to speed up an update

Hi everyone:

I am trying to tune the following update:

update TABLE set column = decode (column, vlaue1..);

The TABLE has about 13mil rows and a primary key. I am thinking of dropping the PK and running the update
with higher degree of parallelism and rebuilding the PK after the update. Is there anything else I should consider? I am running oracle 10.2.0.2

thank you

Gene Gurevich

Please consider the environment before printing this email.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 05 2009 - 13:47:53 CST