RE: Semi-deterministic?

From: Jonathan Lewis <>
Date: Thu, 6 Feb 2014 16:54:31 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDADA4_at_exmbx05.thus.corp>


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.

Jonathan Lewis

From: [] on behalf of Sayan Malakshinov [] Sent: 06 February 2014 15:41
To: Jonathan Lewis
Subject: Re: Semi-deterministic?


My tests showed that, in contrast to deterministic functions caching, scalar subquery caching do not depend on fetch size:

Received on Thu Feb 06 2014 - 17:54:31 CET

Original text of this message