The performance summary of OUTER JOIN vs NOT IN VS NOT EXISTS

Mark this post which is extremely useful to compare performance among these SQL query WHERE methods: https://sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join

Summary in short: NOT EXISTS > EXCEPT or NOT IN > OUTER JOIN methods.

 

Advertisements