Re: How to update a huge table efficiently

Tansel Ozkan <tansel_at_openix.com> writes:

>I need to update a 10 million record table everymonth. About 95% of the
>records will be updated. I am planning to load the update information to
>another table, then run a PL/SQL procedure to update the records that
>are already in the master table or insert the new records that do not
>exist in the master table. But, probably this will be extremely slow.
>Any suggestions on how I can go about doing this would be appreciated...

I am in a similar situation, except that my table has 200,000 records and I need to update it daily and almost 80% of the records are going to be updated every day. I cannot make the database unavailable. Can someone please suggest an efficient way of doing it in SQL ?

Thanks.

Atif Khan
aak2_at_ra.msstate.edu Received on Sun Nov 10 1996 - 00:00:00 CET