RE: Using DUAL

Dual is often used for tasks that can easily be done without making a full roundtrip to the database, not to mention network traffic. Such as getting the system date, the user name, determining basic logic that can be done without going to the database.....  

Regards
Melanie

-----Original Message-----
Sent: Thursday, May 30, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L

The developers here have a fondness for using DUAL for simple operations
(select count(*) from dual is executed 10000+ times per day). I recall a
passing comment somewhere/sometime that there are performance issues with accessing DUAL. Of course, now that I need to provide some information to the developers, I can't recall the comment or find documentation.  

Any assistance is greatly appreciated.

Daniel W. Fink

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Root, Melanie
  INET: mroot_at_ip.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).