Query from DUAL
560055May 5 2009 — edited May 5 2009I am calling a Pl/sql function in a select query which has a statement as below
SELECT SUBSTR(5/2,2,1) INTO m_delim FROM DUAL;
The number of records returned from the calling select query is more 1 million.
How much adversly the query from DUAL table affects the performance of the select query?