Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!85.12.40.139.MISMATCH!xlned.com!feeder7.xlned.com!news2.euro.net!multikabel.net!newsfeed20.multikabel.net!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 04:33:47 -0600 From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server References: Subject: Re: Vanishing table in 11.2.0.3 Date: Thu, 2 Feb 2012 10:34:00 -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: 20 X-Usenet-Provider: http://www.giganews.com X-AuthenticatedUsername: NoAuthUser X-Trace: sv3-QmBtNZVB+C45DGD1SQX3txs0flQB7Ec18j4Ymq2l7yk25jgaVSVa/6KVzIR+PMzKXbR/W0n3Rzlls9P!87zrsWB/GbD1qT7kK+xDVFQlZU5C3jIh3WMrJqLF/Ll8RBD0cKM4qWd08N3cQCGAVr49sv2FkNpG 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: 1527 Xref: news.cambrium.nl And another one worth reading (on Join Elimination) - Christian Antognini http://antognini.ch/2010/01/join-elimination/ -- 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: |