Efficiency comparison of EXISTS and IN

 Posted by Puneet20884 on 1/16/2010 | Category: Sql Server Interview questions | Views: 2209

EXISTS is efficient as if any row returned, Search stops.
IN is looking for a specific match which takes longer.

However they may not always replace each other but wherever they can, above is their efficiency comparison !!

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response