Hi all,
I m new to db2 and I am working with db2 9.1V. I experienced that Merge statement is faster when compared to update.
For updating 15 million records using merge took 17.23 mins and Update statement took 30.11 mins.

Can anyone explain me the reason, whats the strategy that makes Merge faster than Update, even though in Merge also we are using the Update statement only.
Also can any one tell how mergestatement works in the backend?

Thanks in Advance.