Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!xlned.com!feeder3.xlned.com!feeder.erje.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Vanishing table in 11.2.0.3 Date: Thu, 2 Feb 2012 17:54:10 +0000 (UTC) Organization: solani.org Lines: 13 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1328205250 32192 eJwFwQERADEIAzBL8JTSydnB8C/hkww6u8AkcnPlaVB85K7enYrBWPl0y1anE7QQ3ty4dvgDDZsQrQ== (2 Feb 2012 17:54:10 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Thu, 2 Feb 2012 17:54:10 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwFwYEBwDAEBMCViudjnCD2H6F3biHRRHjA1xedt+b5ExqPZX77RHVV2dgJUMiqkzcwzPoBG4YQ7A== Cancel-Lock: sha1:CvpXPRI9T4WnmN8xH/H/1pNt2yI= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXYLQVzhEd/59gwpDrLIgChwOLg7gMb7v1oZBqdscZ+r9Caa3JvSmznHoHkxBx Xref: news.cambrium.nl 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 non- correlated 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