Home » RDBMS Server » Performance Tuning » 'EXISTS' vs 'IN'
'EXISTS' vs 'IN' [message #310336] Tue, 01 April 2008 00:14 Go to next message
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.

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: 65150
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

Previous Topic: SQL Query behaving weirdly in 10g
Next Topic: Creating Materialized View using Union All Operator
Goto Forum:

Current Time: Mon Aug 21 18:55:19 CDT 2017

Total time taken to generate the page: 0.01562 seconds