Re: speeding up updates and insert

From: John Russell <netnews2_at_johnrussell.mailshell.com>
Date: Tue, 23 Apr 2002 04:55:19 GMT
Message-ID: <arp9cu4genp6cp3e4ggkkilq0ar4p6r9o5@4ax.com>

On 22 Apr 2002 10:58:29 -0700, rkg100_at_erols.com (Ryan Gaffuri) wrote:

>I have to update table a and insert new records in table a based on
>records in table b.
>
>Are there any methods for speeding this up other than direct path?

The FORALL statement in PL/SQL lets you run a bunch of INSERT/UPDATE/DELETE statements, each with a slightly different condition that gets read in from a PL/SQL table.

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/

Received on Mon Apr 22 2002 - 23:55:19 CDT