View the exhibit and examine the query and its execution plan from the PLAN_TABLE, Which statement is true about the execution?

Question

Exhibit

Options

• AThe row with the ID column having the value 0 is the first step execution plan.
• BRows are fetched from the indexes on the PRODUCTS table and from the SALES table using full table
• CRows are fetched from the SALES table, and then a hash join operator joins with rows fetched from
• DAll the partitions of the SALES table are read in parallel.

• A
  8% (1)
• B
  15% (2)
• C
  69% (9)
• D
  8% (1)

No community discussion yet for this question.