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

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: Sun Jun 30 14:16:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.