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