SQL SERVER - Better Performance - LEFT JOIN or NOT IN?

home
database
view story

10 Kicks

Kick It

Drop Kick

Kicked

SQL SERVER - Better Performance - LEFT JOIN or NOT IN?(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 1 month ago

What do you think? I am sure result will surprise you.

2 comments |category: Database |Views: 78
Tweet

tags: SQLAuthority pinaldave SQLServer Database SQL another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

tukel(0) -

ryanvs(75) -

khushal999p(275) -

mdopp(856)

More who kicked this story...

Comments:

posted by rsivam(0) 4 years, 1 month ago 0

good one.

posted by ryanvs(75) 4 years, 1 month ago 0

Be careful! This is interesting, but the comments are more interesting. The best comment is #7 from Jason. To summarize, index the tables and use LEFT JOIN unless there is very good reason to do otherwise.

Most Active Users

What's this?