View the exhibit and examine the query and its execution plan from the PLAN_TABLE.
Which statement is true about the execution?
A.
The row with the ID column having the value 0 is the first step execution plan.
B.
Rows are fetched from the indexes on the PRODUCTS table and from the SALES table using
full table scan simultaneously, and then hashed into memory.
C.
Rows are fetched from the SALES table, and then a hash join operator joins with rows fetched
from indexes on the PRODUCTS table.
D.
All the partitions of the SALES table are read in parallel.
Explanation:
C should by correct.
No A, since the first step is ID 6.
No B, since partition range all (id 5) completes before index scan starts
No D, because there’s no parallel execution in the plan.
I agree C is correct