I dont' think it's a limitation in the MERGE statement itself. It's just that the optimizer decided to implement yours in an inefficient way.

Actually, anti-joins are often a pain, not only with MERGE.

SQL Server's MERGE has some limitations and some bugs, but I can tell for sure that Oracle's MERGE is not any better.