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.