Examine the partialPLAN_TABLEoutput:
Which is the correct sequence of execution?(Choose the best answer.)
A.
3, 2, 1, 4, 0
B.
0, 1, 2, 3, 4, 1
C.
0, 4, 1, 3, 2, 1
D.
3, 2, 4, 1, 0
E.
3, 2, 4, 1, 0, 2
Examine the partialPLAN_TABLEoutput:
Which is the correct sequence of execution?(Choose the best answer.)
A.
3, 2, 1, 4, 0
B.
0, 1, 2, 3, 4, 1
C.
0, 4, 1, 3, 2, 1
D.
3, 2, 4, 1, 0
E.
3, 2, 4, 1, 0, 2
D right
A
yes, A
I have put D as it is impossible to perofm join if you have not gound results for the second table.
Have been using this link to analyse: http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf
D – The tabular representation is a top-down, left-to-right traversal of the execution tree. When you read a plan tree you should start from the bottom left and work across and then up. In the above example, begin by looking at the leaves of the tree. In this case the leaves of the tree are implemented using a index scans of the DEPT and the EMP tables. The rows produced by these table scans will be consumed by the join operator. Here the join operator is a nested-loop.
D