SEO

#1 (**permalink**) 02-26-2008, 07:43 AM

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

#2 (**permalink**) 02-26-2008, 07:43 AM

On Sep 26, 3:13 pm, "rogergorden@....gmail.com"
<rogergor...@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.

#3 (**permalink**) 02-26-2008, 07:43 AM

On Sep 26, 6:50 pm, cleveridea <cleveridea....@gmail.com> wrote:
> On Sep 26, 3:13 pm, "rogergorden@....gmail.com"
>
> <rogergor...@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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