Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Expert Query Question...

Re: Expert Query Question...

From: Zbigniew Sliwa <zibi_at_at_hotmail.com>
Date: Wed, 30 Aug 2000 06:52:28 GMT
Message-ID: <Ma2r5.7264$IK4.179314@news.tpnet.pl>

Allen,

I think yes.
I looked into explain plan for those two statements, their both generate the same execution plans (the same costs).



Regards,

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US