168.
Which one has better performance... Exists or a sub-query ( IN clause)?
View Description
Using exists is faster as it returns a Boolean value checking for the existence of records. Where as an 'IN" clause keeps iterating through all the records even if it gets a correct match. So that's waste of resource.