Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Minus Vs Merge

572055May 12 2010 — edited May 12 2010

I have a task of writing records in base tables from staging tables. I need to load only new records in base tables. I am using Merge statement, I got a suggestion to use Minus. I have been said first compare (MINUS) then load in the base area. Please I get a recommendation on what would be better from performance point of view. Base tables volumes are between 100,000 and 6 to 10 millions rows and most of them have got number datatype.

Any help will be highly appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2010

Added on May 12 2010

#general-database-discussions

5 comments

1,440 views