Which is the correct sequence of execution?

Examine the partialPLAN_TABLEoutput:

Which is the correct sequence of execution?(Choose the best answer.)

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


srks

srks

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.