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

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

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

2 comments |category: |Views: 78

tags: another

new 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:
Comments:

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

good one.

Reply

posted by ryanvsryanvs(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.

Reply

information Login or create an account to comment on this story