Description of the illustration vldbg011.eps
This figure 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 serv er set 2 illustrates joins to all servers in parallel execution server set 1. This is where hash(c_customerid) occurs.
-
Parallel execution server set 1 illustrates joins to all in server set 2.
-
The customers table, which is where the SELECT is.