This illustrates a partial partition-wise join between sales and customers.

This is described in the accompanying text. In addition:

• Sales are partitions P1, P2, ... P16.
• Parallel execution server set2 illustrates joins to all servers in parallel execution server set1. This is where the hash(c_customerid) occurs.
• parallel execution server set1 illustrates joins to all in server set2.
• The customers table, which is where the SELECT is.