Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!195.62.100.242.MISMATCH!newsfeed.kamp.net!newsfeed.kamp.net!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!border1.nntp.ams2.giganews.com!border3.nntp.ams.giganews.com!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 02 Feb 2012 03:50:45 -0600 From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server References: Subject: Re: Vanishing table in 11.2.0.3 Date: Thu, 2 Feb 2012 09:50:56 -0000 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 Message-ID: Lines: 23 X-Usenet-Provider: http://www.giganews.com X-AuthenticatedUsername: NoAuthUser X-Trace: sv3-KzMJ/59UePCKKYlD37Xhyyza7pyJccb6GYdFO+G+OvSAstZM9QCM/GDyNVD7SGULMV4XQHpHT2IaZKr!OrAV6vZU+s2jaaMtz/nuyIZ/E8u9nxJymhUwJ0Dbv5nyav0pdCB455BaUlfrfhM3SVe0t1eHxkwY X-Complaints-To: abuse@btinternet.com X-DMCA-Complaints-To: abuse@btinternet.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Bytes: 1639 Xref: news.cambrium.nl 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" wrote in message news:pan.2012.02.02.04.08.17@gmail.com... | Query is extremely simple and the result is expected: | | select ename,job,mgr,deptno,sal from emp | where deptno in (select deptno from dept) | /