When to use EXISTS over IN?

Oracle Apps Interview QuestionsCategory: SQLWhen to use EXISTS over IN?
Questions Master asked 2 years ago
1 Answers
Shailender Thallam Staff answered 2 years ago

EXISTS is very faster than IN when the subquery results is very large
 
IN is faster than EXISTS when the subquery results is very small