RE: Semi-deterministic?
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "xt.and.r@xxxxxxxxx" <xt.and.r@xxxxxxxxx>
- Date: Thu, 6 Feb 2014 16:54:31 +0000
Sayan,
Thanks for the warning. I've put your blog posts on my reading list - it looks
like I've got to bring my test results up to date.
It was unfortunate that the stats just happened to match my current
understanding.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Sayan Malakshinov [xt.and.r@xxxxxxxxx]
Sent: 06 February 2014 15:41
To: Jonathan Lewis
Cc: elkinsl@xxxxxxxxxxx; ORACLE-L
Subject: Re: Semi-deterministic?
Jonathan,
My tests showed that, in contrast to deterministic functions caching, scalar
subquery caching do not depend on fetch size:
http://orasql.org/category/oracle/scalar-subquery-caching/
Other related posts:
