RE: Using DUAL

[Root, Melanie]

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-----
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Subject: Using DUAL

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