RE: Semi-deterministic?
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 6 Feb 2014 16:54:31 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDADA4_at_exmbx05.thus.corp>
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Sayan Malakshinov [xt.and.r_at_gmail.com] Sent: 06 February 2014 15:41
To: Jonathan Lewis
Cc: elkinsl_at_verizon.net; ORACLE-L
Subject: Re: Semi-deterministic?
Date: Thu, 6 Feb 2014 16:54:31 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDADA4_at_exmbx05.thus.corp>
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
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Sayan Malakshinov [xt.and.r_at_gmail.com] Sent: 06 February 2014 15:41
To: Jonathan Lewis
Cc: elkinsl_at_verizon.net; 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/
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 06 2014 - 17:54:31 CET