Re: Need help performing large updates...
From: Kim Ng <kimmng_at_eskimo.com>
Date: 1996/04/12
Message-ID: <DprtHy.DKH_at_eskimo.com>#1/1
Date: 1996/04/12
Message-ID: <DprtHy.DKH_at_eskimo.com>#1/1
Bo Lu (bo.lu_at_hsc.utah.edu) wrote:
: I run into this problem several month ago. Instead of do the update
: within ONE SQL statement, you use PL/SQL to do the update for each
: records. You can setup a counter and commit each 10,000 records.
And if you include "rowid" in your "select" statement in the cursor, you can speed up the update by adding the "rowid" to your where clause.
Have fun.
Kim Ng
Received on Fri Apr 12 1996 - 00:00:00 CEST