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
DB2 upsert
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Perhaps someone else might help; I believe that the price of membership is low copmared to the value received.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>