Skip to content

Left outer Joins Vs Not Exists

October 4, 2013

Aaron Bertrand @ SQL Performance with a great comparison of methods of getting data where other data doesn’t exist

I’m in the habit of using left outer joins, but, as this post explains, you have to be careful when looking at nullable columns

the kicker is the performance gains to be had with NOT EXISTS & EXCEPT

http://www.sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: