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: Why adding "dual" in the "from" clause speeds this query up?

Re: Why adding "dual" in the "from" clause speeds this query up?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 21 Feb 2004 00:02:07 +1100
Message-ID: <4036054e$0$28871$afc38c87@news.optusnet.com.au>


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

> 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:
>
Received on Fri Feb 20 2004 - 07:02:07 CST

Original text of this message

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