Re: select user from dual - performance issue

Ur dual query shud be
  select * from xy where name = (select user from dual) "in" operator always degrades performance...

Uwe Wiedl wrote:
> DUAL table
>
> got a query which uses the "select user from dual" statement.
>
> select * from xy where name in (select user from dual)
> this is up to 10 times slower then
>
> select * from xy where name = user
>
> But this is not for every user in the database the case.
> Why ?
Received on Thu Jun 19 2003 - 04:11:46 CDT