SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deterministic Function and Performance gain. What is the reality behind?

ramarunDec 15 2010 — edited Dec 15 2010

Hello Pros,

What is that we can really gain by using deterministic function. I have seen few threads and good examples by askthom. After reading those examples i feel deterministic functions are rarely being used and the benefits are overlooked. Is my thoughts right? Requst the pro's to discuss on how this deterministic function is being used or how better this can be used in correct places to leverage performance.

[url http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1547006324238#12928321943595]Example from asktom site

Here is the link i had referred to and taken few examples out of it.

Thanks in advance

This post has been answered by Billy Verreynne on Dec 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2011

Added on Dec 15 2010

14 comments

1,942 views