Home » RDBMS Server » Performance Tuning » 'EXISTS' vs 'IN'
'EXISTS' vs 'IN' [message #310336] Tue, 01 April 2008 00:14 Go to next message
vkrn
Messages: 18
Registered: March 2008
Junior Member
Hi all,

Smile. I am confised with the usage of 'EXISTS' and 'IN' in my queries.can anyone guide me in this regard.

Thanks,
Re: 'EXISTS' vs 'IN' [message #310344 is a reply to message #310336] Tue, 01 April 2008 00:21 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read this article from Tom Kyte: http://www.oracle.com/technology/oramag/oracle/06-may/o36asktom.html

Regards
Michel
Previous Topic: SQL Query behaving weirdly in 10g
Next Topic: Oracle execution plan help needed
Goto Forum:
  


Current Time: Wed Dec 07 10:49:50 CST 2016

Total time taken to generate the page: 0.07157 seconds