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,

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read this article from Tom Kyte: http://www.oracle.com/technology/oramag/oracle/06-may/o36asktom.html

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 02:45:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.