Re: Fastest way to update a single column on a large table?

From: Doug Cowles <dcowles_at_i84.net>
Date: 2000/04/27
Message-ID: <390ab634.7553054@news.remarq.com>#1/1

You might try a parallel hint.. that can save a lot of time... /* + parallel(n,12) */ or some such thing where n is an alias for the table.. You should make sure you have the parallel workers available, especially if it is a production system and other things use parallel workers..

On Thu, 27 Apr 2000 13:50:39 +0100, "Tony" <tcommander_at_nsb.co.uk> wrote:

>Any ideas?
>
>I need to update a single column (non-indexed) on a table with around 7
>millions rows in.
>
>Is there any quicker way than just standard update?
>
>Cheers
>Tone
>
>
Received on Thu Apr 27 2000 - 00:00:00 CDT