DB2 upsert

senthilt1 · Post by **senthilt1** » Wed Nov 05, 2008 2:14 am

Hi All,

TO insert records into the table which method in DB2 is fast Either write mode or Upsert mode?

I have seen in a proj, used upsert mode but both the insert and update sql has the same insert query. so whats the diff b/w this upsert and write in this scenario?

Thanks

Senthil P

ArndW · Post by **ArndW** » Wed Nov 05, 2008 2:56 am

Write mode is usually faster. With the "Upsert" method you need to specify both an update and an insert statement, even if you know that the second will never actually be executed, thus both statements can be identical.

senthilt1 · Post by **senthilt1** » Wed Nov 05, 2008 3:55 am

Thanks ArndW,

I got that write mode is faster but i couldnt get your second answer, since i am not a premium user.

Could you give me a hint on that one...

Thanks,
SenthilP

ArndW · Post by **ArndW** » Wed Nov 05, 2008 4:21 am

Perhaps someone else might help; I believe that the price of membership is low copmared to the value received.