Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Isn't PL/SQL Function Result Cache the same as deterministic?
5 views
Skip to first unread message
rogergorden@....gmail.com
Sep 26, 2007, 4:13:11 PM9/26/07
to
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.
the PL/SQL Function Result Cache is the same as using the
deterministic keyword.
Is this the case, or am I missing something?
Roger
cleveridea
Sep 26, 2007, 6:50:47 PM9/26/07
to
On Sep 26, 3:13 pm, "rogergorden@....gmail.com"
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.
rogergorden@....gmail.com
Sep 26, 2007, 7:55:57 PM9/26/07
to
OK, thanks. Now I see the difference. I also see the reason for Mr.
Feuerstein's excitement!!!!!
Roger
0 new messages