Re: nlj batching
From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Sun, 10 Oct 2010 21:12:36 +0300
Message-ID: <4CB20214.90103_at_iki.fi>
Date: Sun, 10 Oct 2010 21:12:36 +0300
Message-ID: <4CB20214.90103_at_iki.fi>
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:Received on Sun Oct 10 2010 - 13:12:36 CDT
> 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