Hi all,
I have scenario where data is dumped in a temp table. It contains around 5 million records. From the temp table data is to be upsert to target table with same structure as temp table.
At present this is being done by MERGE statement. Although there are indexes on target table, it still takes around 4 hrs and above for completion.

As an alternative I am thinking of testing the performance using an PLSQL using cursors.But prior to that I would request if you can suggest anything that would be the best alternative and of course an improvement to the performance.

Thanks.
Ranjan