How to speed up an update
From: <genegurevich_at_discover.com>
Date: Thu, 5 Mar 2009 12:22:45 -0600
Message-ID: <OFBB0038C2.882FFFC2-ON86257570.0064A9BC-86257570.0064FB97_at_discover.com>
Hi everyone:
Date: Thu, 5 Mar 2009 12:22:45 -0600
Message-ID: <OFBB0038C2.882FFFC2-ON86257570.0064A9BC-86257570.0064FB97_at_discover.com>
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-lReceived on Thu Mar 05 2009 - 12:22:45 CST