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?
"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
![]() |
![]() |