Description of the illustration vldbg004b.eps

The operations in the diagram, starting from the bottom of the diagram and moving upward, are:

• a full scan is done of customers

• a full scan is done of sales

• a HASH JOIN and GROUP BY is performed

• a GROUP BY SORT is performed

• the parallel execution coordinator is the final element

This diagram is also discussed in the accompanying text.