I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other.
The other day my DBA told me the following:
Take a look at this, MERGE statement cold be more elegant but it provokes big problems in performance.
I'm not an expert in this, but it doesn't make sense to me. And looking in the date of the publication of the article (December, 2008) looks like in could be out of date.
We work in Oracle 11g
Should I rewrite my procedures to avoid MERGE? Thanks!