Link Details

Link 396035 thumbnail
User 425332 avatar

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

This article explores the myth that a SQL JOIN is necessarily more efficient than using an IN statement in the WHERE clause. Interesting stuff.
  • 19
  • 0
  • 3773
  • 0

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.

Apache Hadoop
Written by: Piotr Krewski
Featured Refcardz: Top Refcardz:
  1. Play
  2. Akka
  3. Design Patterns
  4. OO JS
  5. Cont. Delivery
  1. Play
  2. Java Performance
  3. Akka
  4. REST
  5. Java