Extra NESTED LOOPS Step In Explain Plan on 11g and Above
Last updated on MARCH 26, 2015
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
When looking at the access path for a query in 11g, the plan looks different when compared to 10g.
The 11g plan contains an extra nested loops step.
The row source plan is the same as the explain plan.
For example in 11g a plan might look like:
Moving to 11g from an earlier release.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms