1Z0-117 Web TestEngine demo

The row with the ID column having the value 0 is the first step execution plan.

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.

Rows are fetched from the SALES table, and then a hash join operator joins with rows fetched from indexes on the PRODUCTS table.

All the partitions of the SALES table are read in parallel.