Is separate insert / update more efficient than upsert?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
myukassign
Premium Member
Premium Member
Posts: 238
Joined: Fri Jul 25, 2008 8:55 am

Is separate insert / update more efficient than upsert?

Post by myukassign »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Upsert is never 'more efficient' unless, perhaps, your mechanism to determine one from the other is highly inefficient. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply