How to speed up an update

From: <>
Date: Thu, 5 Mar 2009 12:22:45 -0600
Message-ID: <>

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

thank you

Gene Gurevich

Please consider the environment before printing this email.

Received on Thu Mar 05 2009 - 12:22:45 CST

Original text of this message