View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 07:43 AM
cleveridea
 
Posts: n/a
Default Re: Isn't PL/SQL Function Result Cache the same as deterministic?

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.

Reply With Quote