Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Expert Query Question...
Yes.
Oracle optimizer is smart enough to see that "IN (1)" is the same as "= 1".
-- Have a nice day Michel Allen <allen.brost_at_motorola.com> a écrit dans le message : 39AABF8B.3653E8FB_at_motorola.com...Received on Tue Aug 29 2000 - 02:49:10 CDT
> is the statement:
>
> SELECT * FROM table WHERE value IN (1);
>
> going to produce the same performance as:
>
> SELECT * FROM table WHERE value = 1;
>
>
> - Allen
>
>