Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Isn't PL/SQL Function Result Cache the same as deterministic?
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. Received on Wed Sep 26 2007 - 17:50:47 CDT
![]() |
![]() |