I have a continously growing table. I have to perform an insert update. Please suggest me which is the best approach.
1. Do update in Job 1, Then do insert in Job 2
2. Select Upsert mode and do it in one job.
Which is more efficient and faster? I am using Db2 stage. Will I face any perfomance hit by doing insert/udpate in one job.
Is separate insert / update more efficient than upsert?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am