Re: speeding up updates and insert

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Apr 2002 19:14:35 +0100
Message-ID: <1019499197.823.0.nnrp-08.9e984b29@news.demon.co.uk>

In Oracle 9 there is the new MERGE
command, which is effectively an
array insert/update to one table
based on a select from another table.

You have to watch out for a uniqueness
trap in the incoming data, but otherwise it works very well and very quickly.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Ryan Gaffuri wrote in message
<6757365f.0204220958.a804296_at_posting.google.com>...


>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?

Received on Mon Apr 22 2002 - 13:14:35 CDT