Hi,

Had a similar query on merge, merge when used on large data takes a very long time to execute. I have data count of over 14 million records, where i am comparing 5 columns data with target table if there is any difference then my merge statement creates a new record if data is matched then merge updates old record.

Is there any other optimized way to perform this operation besides merge statement. ?

Any help would be appreciated.

Thanks,

-Jack