Delete-Insert OR Merge

[himridul]

Hi,

A table has 500 millions of rows . Now I have to update around 0.4 million of rows in the table.

Can you tell me which process would be faster for this criterian :

1. Delete-Insert (Deleting the existing rows and Insert the updated rows)

2.Merge(Update else Insert)

Thanks ..

 

[SantaMufasa]

Himridul,

You are updating less than 1/2 of 1% of your table. These are relatively few updates. If you have indexes on your table, update/insert should go very quickly (...faster than delete/insert to accomplish an update.)

Mufasa
(aka Dave of Sandy, Utah, USA @ 08:41 (11Feb04) UTC (aka "GMT" and "Zulu&quot, 01:41 (11Feb04) Mountain Time)

 

[himridul]

Thanks