Re: select user from dual - performance issue

Uwe Wiedl wrote:

> 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.

Does not make sense to me.. (no big surprise there)

What does the explain plans say?

What does v$session_wait say when it is slow?

--
Billy