CodePudding user response:
How to see, from inside to outside, from top to bottom,This question is too broad, however, each SQL execution plan is different, want to clear the path of the access object, table joins, the CBO, statistics, etc.
May have a look the document overview,
"Oracle execution plan _ Luo Haixiong"