Received: (qmail 27487 invoked from network); 10 Oct 2010 13:16:56 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 10 Oct 2010 13:16:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F120D40BE4; Sun, 10 Oct 2010 14:16:51 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1286734611; bh=Bun2h8QZvm1rrDDJK5Sqs315WcsQAGX5mmDiQMiY lOs=; h=Message-ID:Date:From:MIME-Version:To:Subject:References: In-Reply-To:Content-Type:Content-Transfer-Encoding:Sender:Reply-To: List-help:List-unsubscribe:List-Id:List-subscribe:List-owner: List-post:List-archive; b=arRyyZJflLBEFK1SZDfyT6O6ZUwrx2Sc+KS+67UF YMfcPhOBH8yxrM3tJdIl4st9uZPYYyiBDDLLjP9ASgoGcfhtQSy731N3+rfnnGGJ1S8 XGPETjiWwQzV8lWYiZNaMf183qAYlYq9/jf8fonVzwll/lcZrKzuWoUhA7IPkKuA= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3nRwisRSK3N3; Sun, 10 Oct 2010 14:16:50 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 947AFD40D2B; Sun, 10 Oct 2010 14:16:07 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 10 Oct 2010 14:15:26 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9C53D40BFF for ; Sun, 10 Oct 2010 14:15:25 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UwBSbBbNYw5Y for ; Sun, 10 Oct 2010 14:15:25 -0400 (EDT) Received: from mail.cs.tut.fi (mail.cs.tut.fi [130.230.4.42]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54C38D40BE4 for ; Sun, 10 Oct 2010 14:15:24 -0400 (EDT) Received: from amavis2.cs.tut.fi (amavis2.cs.tut.fi [130.230.4.70]) by mail.cs.tut.fi (Postfix) with ESMTP id 574CF996 for ; Sun, 10 Oct 2010 21:15:23 +0300 (EEST) Received: from mail.cs.tut.fi ([130.230.4.42]) by amavis2.cs.tut.fi (amavis2.cs.tut.fi [130.230.4.70]) (amavisd-maia, port 10024) with ESMTP id 23102-05 for ; Sun, 10 Oct 2010 21:15:22 +0300 (EEST) Received: from [192.168.100.20] (e81-197-73-229.elisa-laajakaista.fi [81.197.73.229]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.cs.tut.fi (Postfix) with ESMTP id 90F58995 for ; Sun, 10 Oct 2010 21:15:22 +0300 (EEST) Message-ID: <4CB20214.90103@iki.fi> Date: Sun, 10 Oct 2010 21:12:36 +0300 From: Timo Raitalaakso User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.12) Gecko/20100914 Thunderbird/3.0.8 MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: nlj batching References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-archive-position: 31507 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rafu@iki.fi Precedence: normal Reply-To: rafu@iki.fi List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Is there something else to say that is not in documentation? http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/optimops.htm#BABFCIAI -- Rafu http://rafudb.blogspot.com/ On 10.10.2010 20:39, joshuasingham wrote: > Hi all, > I been going through some notes and wandering if anybody know the > benefits of nlj batching for example in 10g i get this plan (as shown > below) which then in 11g in converts into 2 nested loop join my > question would be why will this be a good compared to 10g > > Oracle 10g > ------------------------------------------------ > | Id | Operation | Name | > ------------------------------------------------ > | 0 | SELECT STATEMENT | | > | 1 | TABLE ACCESS BY INDEX ROWID | T2 | > | 2 | NESTED LOOPS | | > | 3 | TABLE ACCESS BY INDEX ROWID| T1 | > |* 4 | INDEX RANGE SCAN | T1_N1 | > |* 5 | INDEX RANGE SCAN | T2_N1 | > ------------------------------------------------ > > Oracle 11g > ------------------------------------------------ > | Id | Operation | Name | > ------------------------------------------------ > | 0 | SELECT STATEMENT | | > | 1 | NESTED LOOPS | | > | 2 | NESTED LOOPS | | > | 3 | TABLE ACCESS BY INDEX ROWID| T1 | > |* 4 | INDEX RANGE SCAN | T1_N1 | > |* 5 | INDEX RANGE SCAN | T2_N1 | > | 6 | TABLE ACCESS BY INDEX ROWID | T2 | > > thanks > -- http://www.freelists.org/webpage/oracle-l