If the outer query is “big” and the inner query is “small”, IN is generally more efficient than EXISTS . If outer query is “small” and the inner query is “big”, then EXISTS is quite efficient.