Re: Six of one . . .

From: John Russell <netnews4_at_johnrussell.mailshell.com>
Date: Thu, 19 Sep 2002 04:01:43 GMT
Message-ID: <ukiioug7t8id3l2uk2ljdombsvjojrg61l@4ax.com>

On Tue, 17 Sep 2002 13:14:39 -0700, Martin Doherty <martin.doherty_at_oracle.com> wrote:

>Ed, my gut agrees with your gut. Initiating a new query for each row to be
>processed sounds pretty resource-heavy compared with submitting a single query that
>identifies all rows to be processed.

I would also stick all the updated data into a PL/SQL collection (probably an index-by table) and then use the FORALL to loop through all the UPDATE statements. It's much faster than doing a separate UPDATE for each changed row.

John Received on Wed Sep 18 2002 - 23:01:43 CDT