Re: Isn't PL/SQL Function Result Cache the same as deterministic?

From: <rogergorden_at_....gmail.com>
Date: Wed, 26 Sep 2007 16:55:57 -0700
Message-ID: <1190850957.850691.62990@57g2000hsv.googlegroups.com>

On Sep 26, 6:50 pm, cleveridea <cleveridea...._at_gmail.com> wrote:
> On Sep 26, 3:13 pm, "rogergorden@....gmail.com"
>
> <rogergor..._at_gmail.com> wrote:
> > I am reading Feuerstein's article in Oracle Magazine and is seems as
> > the PL/SQL Function Result Cache is the same as using the
> > deterministic keyword.
>
> > Is this the case, or am I missing something?
>
> > Roger
>
> A deterministic function NEVER involves results from tables. A cached
> function result takes advantage of cursor results much like the buffer
> cache, except at a much leaner and meaner granularity.

OK, thanks. Now I see the difference. I also see the reason for Mr. Feuerstein's excitement!!!!!

Roger Received on Wed Sep 26 2007 - 18:55:57 CDT