A question asked multiple times over on Oracle forums: Which is faster - IN or EXISTS? The short answer, post-Oracle 9i is: Both are pretty much the same!