MERGE can't be used for Parallel Executions?? Flaw?
Can someone give an example of doing this using the Merge statement? We do a load (Insert + update) in multiple sessions simulateneously
A typical load will do this:
Update where exists
Insert NOT EXISTS
If we do this using new merge statement, we sometimes get unique key violation where two processes are trying to do the same thing, one goes through with the insert while the other fails with a unique constraint violation. There's got to be a way of putting not exists condition in the Merge INSERT statement, otherwise it won't work in a parallel environment.
thanks for your help in advance