View the exhibit and examine the query and its execution plan from the PLAN_TABLE.
Which statement is true about the execution?
Exhibit:
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |