Home » SQL & PL/SQL » SQL & PL/SQL » Exists and In operator (Oracle 10g)
Exists and In operator [message #297818] Sun, 03 February 2008 22:30 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,

Exists and In how differs by execution wise? Which one is faster?
Re: Exists and In operator [message #297850 is a reply to message #297818] Mon, 04 February 2008 00:05 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
It depends upon situation and process as both have some specialities.

regards,
Re: Exists and In operator [message #297869 is a reply to message #297818] Mon, 04 February 2008 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Exists" is always faster but Oracle likes to fool people, so it also introduced "in".

Just kidding of course.
If both exist then both have their usage.

But if you have statistics up to date, Oracle will choose the correct path for you.

Regards
Michel
Re: Exists and In operator [message #297871 is a reply to message #297818] Mon, 04 February 2008 01:32 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at the following article:
http://www.oracle.com/technology/oramag/oracle/06-may/o36asktom.html

Regards
Michel
Previous Topic: What is the usage of For Update Clause and Where current of
Next Topic: Oracle Job not running properly:
Goto Forum:
  


Current Time: Sun Dec 04 16:45:31 CST 2016

Total time taken to generate the page: 0.04640 seconds