in operator [message #291412] |
Fri, 04 January 2008 02:18  |
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 #291427 is a reply to message #291412] |
Fri, 04 January 2008 03:09  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|