Examine the Exhibit and view the query and its execution plan.
Which statement is correct about the parallel executions plan?
A.
The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined in
parallel.
B.
First, the CUSTOMERS table is scanned in parallel, then the SALES table is scanned in
parallel, and then they are joined serially.
C.
First, the SALES table is scanned in parallel, then the CUSTOMERS table us scanned in
parallel, and then they are joined in parallel.
D.
The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined
serially.
E.
First, the CUSTOMERS table is scanned in parallel, then the SALES table us scanned in
parallel, and then they are joined in parallel.
Explanation:
As per exhibit:
Line 7 and line 11 are run in parallel.
Line 8 and line 12 are run in parallel.
Line 9 and line 13 are run in parallel.
Line 10 and line 14 are run in parallel.
Line 6 serially joins the two parallel scan (resulting from line 7 and 11).
Note:
* PX BLOCK ITERATOR
The PX BLOCK ITERATOR row source represents the splitting up of the table EMP2 into pieces
so as to divide the scan workload between the parallel scan slaves.
Correct Answer is E
Agree, E correct.
Agree too, E is correct