Home Forums SQL Server 7,2000 T-SQL WHERE IN(sub-query) vs. INNER JOIN RE: WHERE IN(sub-query) vs. INNER JOIN
Goldy-192585
SSC Enthusiast
Points: 156
More actions
December 15, 2004 at 12:34 pm
#534026
I had read an article about using "exists" instead of "In". I think it mentioned that exists would just check for a condition to find out if its true or false; but "In" clause actually retrieves a result set and hence is much slower.