Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!192.87.166.28.MISMATCH!tudelft.nl!txtfeed1.tudelft.nl!multikabel.net!newsfeed10.multikabel.net!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 13:17:01 +0000 (UTC) Organization: solani.org Lines: 28 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1328188621 17597 eJwNycEBwEAEBMCWEBblcJftv4RkvhMPFCcdAQ8Gm9bX0HmA2bU9RZrIP6brL5EzdK0a4ZX4ACOuEWg= (2 Feb 2012 13:17:01 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Thu, 2 Feb 2012 13:17:01 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwFwYEBwDAEBMCVqPyTcQj2H6F3MCqfH4IHi81nsTWIjhykiNoMP0Xf1NauEp9ruUlDw38ythG2 Cancel-Lock: sha1:cJgoRvFFyFEZanJKqFcn+1GL4E8= X-NNTP-Posting-Host: eJwNyskBwDAIA7CVSjgM46QY9h+h1VuuIdGw8DBfX1Ya2Hjoegf1Uiu9MptrcnkOJtB/7okR/QAfZxEk Xref: news.cambrium.nl On Thu, 02 Feb 2012 09:47:48 +0000, Jonathan Lewis wrote: > So many questions in such a short space. > > Table Elimination - > The IN subquery is transformed into EXISTS The EXISTS subquery is > single table based on a declared primary key, > therefore is subject "uncosted unnesting" (I think, that's the rule > applied here) Ah, I forgot about that. I only looked whether the column was indexed or not. > There is no "push_subq" in this plan, by the way. Push_subq (in > principle) means that Oracle will run the subquery at the earliest > possible moment rather than leaving it to the end of the plan. 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. -- http://mgogala.byethost5.com