Between EXISTS and In which one is more performance friendly?

Questions by jayanta_bits

Showing Answers 1 - 3 of 3 Answers

Catalina

  • Sep 25th, 2007
 

It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while the subquery is heighly selective, then you the hole query will execute better when using IN 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions