Re: How to speed up an update
Date: Thu, 5 Mar 2009 15:40:21 -0600
Message-ID: <OF80A0A08A.128569DF-ON86257570.00770536-86257570.007712C7_at_discover.com>
Yes. it is part of the primary key. When I dropped the pk, the timing decreased significantly.
thank you
Gene Gurevich
Toon Koppelaars
<toon.koppelaars_at_
rulegen.com> To
genegurevich_at_discover.com
03/05/2009 12:58 cc
PM oracle-l_at_freelists.org
Subject
Re: How to speed up an update
Is "column" involved in the primary key? This is not clear from your question.
On Thu, Mar 5, 2009 at 7:22 PM, <genegurevich_at_discover.com> wrote: 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
--
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
(co)Author: "Applied Mathematics for Database Professionals"
Please consider the environment before printing this email.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 05 2009 - 15:40:21 CST