Thread
:
Join vs subselect
View Single Post
#
1
(
permalink
)
02-28-2008, 09:44 AM
=?iso-8859-1?B?QW5kcukgSORuc2Vs?=
Posts: n/a
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é
=?iso-8859-1?B?QW5kcukgSORuc2Vs?=