The truth about IN and EXISTS in SQL

Very nice article, finally getting rid of some doubts… (at least for Oracle)

http://explainextended.com/2009/09/30/in-vs-join-vs-exists-oracle/