MERGE vs DELETE/INSERT in Oracle 10g

Question

I have a procedure that is run often (~1000x every 5 mins) in Oracle 10g. The basic idea is to refresh data in a table based on the PK.

Which has a better performance in terms of IO/CPU load on the database? DELETE by PK then INSERT or a MERGE on PK?

With MERGE you can do INSERTs, UPDATEs, and DELETEs. Not sure what you're asking here. — Patrick Marchand, Oct 11 '13 at 15:53

score 1 · Accepted Answer · answered Oct 18 '13 at 09:41

1

MERGE is almost always slower then special crafted DELETEs with BULK INSERTs. Its only more convient to use in some cases.

On the other hand, if you don't use any tricks to speedup your queries performance will be almost the same.

answered Oct 18 '13 at 09:41

Nagh

1 Answers1