Re: Vanishing table in 11.2.0.3

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 2 Feb 2012 17:54:10 +0000 (UTC)
Message-ID: <jgeik2$ve0$1_at_solani.org>



On Thu, 02 Feb 2012 14:00:22 +0000, Jonathan Lewis wrote:

> You're thinking of the undocumented /*+ precompute_subquery */ hint.

To tell the truth, that does look very similar to push_subq. With noncorrelated  subqueries, the result is probably very similar, in both cases. I don't think that it is possible to pre-compute a correlated subquery.

-- 
http://mgogala.byethost5.com
Received on Thu Feb 02 2012 - 11:54:10 CST

Original text of this message