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.