its an extra network round trip. so if you do it alot its alot of extra network round trips. There are two known(pre-10g ways) to improve dual.
Make a copy of dual as an index organized table and make a synonym that points to the new IOT. The biggest improvement seems to come from making a view on the x$dual table and making a dual synonym point to that. I have seen that published in several places, but have been hesitant to use it since its an x$table(maybe I'm being too conservative)
I played with 10g just a little bit, but have not read much of the documentation. It seems like there is a 'fast dual' that has no consistent gets, which is the same as hitting the x$dual table which seems to be done by default. Maybe someone else can provide more detauls.
-------------- Original message --------------
>
> Is there any performance benefit selecting from dual in sqlplus as compared
> to selecting dual from a packaged procedure? The reason I ask is that we
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Fri Sep 10 2004 - 12:10:42 CDT
