Examine the Exhibit.
Given two sets of parallel execution processes, SS1 and SS2, which is true?
A.
Each process SS1 reads some of the rows from the CUSTOMERS table and sends all the rows
it reads to each process in SS2.
B.
Each process in SS1 reads all the rows from the CUSTOMERS table and distributes the rows
evenly among the processes in SS2.
C.
Each process in SS1 reads some of the rows from the SALES table and sends all the rows it
reads to each process in SS2.
D.
Each process in SS1 reads all the rows from the SALES table and distributes the rows evenly
among the processes in SS2.
E.
Each process in SS1 reads some of the rows from the SALES table and distributes the rows
evenly among the processes in SS2.
F.
Each process in the SS1 reads some of the rows from the CUSTOMERS table and distributes
the rows evenly among the processes in SS2.
Explanation:
Note:
* The execution starts with line 16 (accessing the SALES table), followed by line 15.
* PX BLOCKITERATOR
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.
The PX SEND and PX RECEIVE row sources represent the pipe that connects the two slave sets
as rows flow up from the parallel scan, get repartitioned through the HASHtable queue, and then
read by and aggregated on the top slave set.
For me E is correct