nlj batching
- From: joshuasingham <joshuasingham@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 11 Oct 2010 01:39:29 +0800
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
Other related posts:
