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 -> select user from dual - performance issue

select user from dual - performance issue

From: Uwe Wiedl <uwe.wiedl_at_web.de>
Date: 19 Jun 2003 01:42:58 -0700
Message-ID: <a325abab.0306190042.6a815e03@posting.google.com> 





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 - 03:42:58 CDT












Original text of this message













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