Assume a Sales table with a has partition on the cust_id colum. Assume the query Select num (ssales_amount) from SALES.s CUSTOMER.c wjere s.cust_id = c.cust_id. In this case rows from Customer are dynamically redistributed on the join key cust_idto enable partition-wise join.