168.

Which one has better performance... Exists or a sub-query ( IN clause)?

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.