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:
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.comReceived on Thu Feb 02 2012 - 11:54:10 CST