Re: Performance when own functions are used

No,
As long as you don't have functions with selects embedded in a different select, there shouldn't be any performance problems. From your example it is not clear what you try to accomplish, your function looks like a wrapper for an existing function, and thus, IMO, redundant.

Hth,

Sybrand Bakker, Oracle DBA

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message news:8qa92k$iaq$10$1_at_news.t-online.com...
> Short question,
>
> If I use a stored function as an replacement for an oracle function like
>
> CREATE OR REPLACE FUNCTION SP_SIGN (nBetrag IN NUMBER)
> return integer
> as
> begin
> return SIGN(NBETRAG);
> end SP_SIGN ;
> /
>
> Does that decrease the performance or not?
> Regards
>
> Grüsse
> Nicolas
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT