using the IN clause, you're telling the rule-based 
optimizer that you want the inner query to drive the outer 
query (think: IN = inside to outside). 

When you write EXISTS in a where clause, you're telling the 
optimizer that you want the outer query to be run first, 
using each value to fetch a value from the inner query 
(think: EXISTS = outside to inside). 

Thank you