Re: Vanishing table in 18.104.22.168
Date: Thu, 2 Feb 2012 17:54:10 +0000 (UTC)
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.Received on Thu Feb 02 2012 - 11:54:10 CST