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: Vitalo Pedrotti <vitalisREMOVETHAT_at_numericable.fr>
Date: Fri, 20 Feb 2004 18:20:42 +0100
Message-ID: <403641e3$0$21687$636a15ce@news.free.fr>


"Noons" <wizofoz2k_at_yahoo.com.au> a écrit dans le message de news: 4036054e$0$28871$afc38c87_at_news.optusnet.com.au...
> Where is dual added to again?
> (you provided an example *without* the dual table)

At the end of the "from" clause:
...
FROM table_r r, table_v v, table_c c, dual ... Received on Fri Feb 20 2004 - 11:20:42 CST

Original text of this message

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