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
Messages: 240
Registered: June 2005
Location: India
Senior Member

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);

Re: in operator [message #291424 is a reply to message #291412] Fri, 04 January 2008 03:02 Go to previous messageGo to next message
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: 63911
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.

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

Current Time: Sun Oct 23 05:00:19 CDT 2016

Total time taken to generate the page: 0.08692 seconds