Re: Vanishing table in 11.2.0.3
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Feb 2012 14:00:22 -0000
Message-ID: <dLednWWqm75HC7fSnZ2dnUVZ8lKdnZ2d_at_bt.com>
Date: Thu, 2 Feb 2012 14:00:22 -0000
Message-ID: <dLednWWqm75HC7fSnZ2dnUVZ8lKdnZ2d_at_bt.com>
You're thinking of the undocumented /*+ precompute_subquery */ hint.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Oracle Core (Apress 2011) http://www.apress.com/9781430239543 "Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:pan.2012.02.02.13.17.01_at_gmail.com...Received on Thu Feb 02 2012 - 08:00:22 CST
|
| That is what I thought. I thought that the subquery was executed first,
| as a part of the parse, and turned into an explicit in-list. That's why I
| mentioned push_subq.
|