Update vs Merge


Update vs Merge

Hi Team,


   I had a Update query to update 3 columns (out of 100 columns) in a table that had 3 billion records. The update was running for 5 hours.


   While i changed the query to use Merge, the update happened in very less time (10 minutes). I have a question now, Is merge logic more efficient compared to Update on a table with huge record counts?


   The update/merge is using the join on their key columns



Parthiban V