HTML5 Mobile
Written by: Max Firtman
Featured Refcardz: Top Refcardz:
  1. Git
  2. Data Mining
  3. Spring Data
  4. Subversion
  5. HTML5 Mobile
  1. HTML5 Mobile
  2. HTML5
  3. Subversion
  4. Git
  5. Java
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!

Link 396035 thumbnail
User 425332 avatar

By JohnFx
via explainextended.com
Published: Apr 14 2010 / 09:15

IN vs. JOIN vs. EXISTS
This article explores the myth that a SQL JOIN is necessarily more efficient than using an IN statement in the WHERE clause. Interesting stuff.
Vote up
Vote down
  • 19
  • 0
  • 3498
  • 0
SaveShareSend Tags: ,

Comments

Add your comment
User 226303 avatar

devdanke replied ago:

0 votes Vote down Vote up Reply

Wow. Thanks for bringing this up. It's always nice when old assumptions are challenged in the light of newer technology (i.e. new implementations of RDMS).

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.