View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 09:44 AM
=?iso-8859-1?B?QW5kcukgSORuc2Vs?=
 
Posts: n/a
Default Join vs subselect

Hi,

is there a difference in performance between
SELECT a.* FROM a INNER JOIN b USING (some_key)
and
SELECT * FROM a WHERE EXISTS (SELECT * FROM b WHERE a.some_key =
b.some_key)
?

Regards,
André

Reply With Quote