SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Several nested loop at the same level in an execution plan

490609Feb 25 2012 — edited Feb 26 2012

Hi, I am using 11gR2, and I've seen a execution plan in the trace of my SQL query (also shown in pl/sql explain plan) with 4 nested loops all at the same level, what does this mean?

i.e.

- SELECT STATEMENT, GOAL = FIRST_ROWS
+ NESTED LOOPS
+ NESTED LOOPS
+ NESTED LOOPS
+ NESTED LOOPS

each NESTED LOOP can be expanded to 2 further actions, which make sense to me. e.g.
+ NESTED LOOPS
+ TABLE ACCESS BY INDEX ROWID
+ TABLE ACCESS BY INDEX ROWID

THANKS
Ye

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2012

Added on Feb 25 2012

#11g, #9i

5 comments

1,794 views