tripleAxe (11/26/2014)
My question about this would be does is the IF EXISTS still perform better from a performance point of view once we start using tables with millions of rows. I think it will depend upon indexing, data distribution and if the row already exists or not, and possibly other variables I've not thought of.
In a situation like this, IF EXISTS will always perform beter.
However, if given the option, MERGE will usually outperform both.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”