Re: Vanishing table in

From: Mladen Gogala <>
Date: Thu, 2 Feb 2012 17:54:10 +0000 (UTC)
Message-ID: <jgeik2$ve0$>

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

Original text of this message