Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why adding "dual" in the "from" clause speeds this query up?
Where is dual added to again?
(you provided an example *without* the dual table)
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospam "Vitalis" <vitalopedrotti_at_yahoo.fr> wrote in message news:4e6dd3ba.0402200456.56c741bb_at_posting.google.com...Received on Fri Feb 20 2004 - 07:02:07 CST
> A friend of mine told me that one of his complicated queries was
> wondrously speed up when he added "dual" to the "from" clause.
> The query looks like:
>
![]() |
![]() |