Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Expert Query Question...
Allen,
I think yes.
I looked into explain plan for those two statements,
their both generate the same execution plans
(the same costs).
Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com
Allen napisa³(a) w wiadomoœci: <39AABF8B.3653E8FB_at_motorola.com>...
>is the statement:
>
>SELECT * FROM table WHERE value IN (1);
>
>going to produce the same performance as:
>
>SELECT * FROM table WHERE value = 1;
>
>
>- Allen
>
>
Received on Wed Aug 30 2000 - 01:52:28 CDT