Re: Vanishing table in 11.2.0.3
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Feb 2012 09:50:56 -0000
Message-ID: <w42dnfvRe7TowbfSnZ2dnUVZ7oudnZ2d_at_bt.com>
Date: Thu, 2 Feb 2012 09:50:56 -0000
Message-ID: <w42dnfvRe7TowbfSnZ2dnUVZ7oudnZ2d_at_bt.com>
I failed to supply the link to part 3 of Randolf's series http://oracle-randolf.blogspot.com/2011/08/logical-io-evolution-part-3-11g.html
-- 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.04.08.17_at_gmail.com...Received on Thu Feb 02 2012 - 03:50:56 CST
| Query is extremely simple and the result is expected:
|
| select ename,job,mgr,deptno,sal from emp
| where deptno in (select deptno from dept)
| /