Compare IN and EXISTS in subqueries

This week’s Oracle e-newsletter explains the difference between IN and EXISTS in subqueries.

Do you tend to avoid the EXISTS clause because of the requirement to return a result from the query? Does this e-newsletter provide you with helpful tips to determine whether the IN or the EXISTS clause offers better performance in rule-based optimization? Please let us know.

If you aren’t subscribed to the free Oracle e-newsletter, click the following link to automatically sign up:
http://nl.com.com/MiniFormHandler?brand=builder&subs_channel=bldr_front_door&list_id=e050&tag=fb