Home » SQL & PL/SQL » SQL & PL/SQL » in operator (oracle,9i,SunOs)
in operator [message #291412] Fri, 04 January 2008 02:18 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi.

Anybody could explain me what is the difference in the below two queries regarding performance.

select * from emp
where empno=7900;


select * from emp
where empno in(7900);


Thanks.
Re: in operator [message #291424 is a reply to message #291412] Fri, 04 January 2008 03:02 Go to previous messageGo to next message
orafan23
Messages: 13
Registered: December 2005
Junior Member
Not Much! Both use the same plan.
Re: in operator [message #291427 is a reply to message #291412] Fri, 04 January 2008 03:09 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No difference neither regarding performances or other thing.
Just execute them with "set autotrace on" and see the explain plan.

Regards
Michel
Previous Topic: Calling member procedure from member function
Next Topic: how to write select query
Goto Forum:
  


Current Time: Sun Dec 04 04:25:10 CST 2016

Total time taken to generate the page: 0.10252 seconds