Re: user-defined functions

In the past I have been working with user-defined functions in selects which were issuing additional selects (I didn't design them luckily). The performance of this was usually quite bad, because the select in the pl/sql function of course was treated as a seperate select, and was not merged into the main select. There were quite a few examples where one single select would have resulted in the optimizer choosing better access paths. But then again, I didn't design them, and I couldn't convince the guys who did to change the application.

Hth,

Sybrand Bakker, Oracle DBA

Young-gyun Koh wrote:

> I was told that the use of user-defined functions in queries may slow down
> the performance.
>
> Is that true? then, that's why?
>
> thanks
> regards
>
> immortal_at_in4bank.com
> InfoBank Corp.

Received on Wed Dec 30 1998 - 00:26:39 CST