DB2 Merge performance

[ashish5185]

I have a base table with almost 8 million records.
There are 2 tables one containing the new inserts and other containing updates to the base table.
Now I have two options:-
1. Use Update statement and then Insert into the base table.

2. Use Merge statement on base table and staging table that will contain both the inserts as well as updated records.

This query needs to be run everyday.
Which approach should I follow considering the performance criteria?

I would appreciate any help to the above problem?

[FritzLeblanc]

I have a base table with almost 8 million records.
There are 2 tables one containing the new inserts and other containing updates to the base table.
Now I have two options:-
1. Use Update statement and then Insert into the base table.

2. Use Merge statement on base table and staging table that will contain both the inserts as well as updated records.

This query needs to be run everyday.
Which approach should I follow considering the performance criteria?

I would appreciate any help to the above problem?

I'm not sure you've provided enough information. The answer may depend on how many rows are in the insert and updates tables. If they're small relative to the base table, then I'd go with option 1. Probably the best thing you can do is to test both options and choose the option that performs best in your environment.

Fritz