Update vs Merge

General
Enthusiast

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

 

Regards

Parthiban V