Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why functions in Select Clause affect performance?
Oracle will run the function over each row returned, if the SQL returns
1 million rows then the function will be executed 1 million times and
if it does something slow then it will do that slow thing 1 million
times.
Received on Tue Apr 04 2006 - 20:27:41 CDT