Expression DISTRIBUTE

DISTRIBUTE(recordset, expression )

This form redistributes the recordset based on the specified expression, typically one of the HASH functions. Only the bottom 32-bits of the expression value are used, so either HASH or HASH32 are the optimal choices. Records for which the expression evaluates the same will end up on the same node. DISTRIBUTE implicitly performs a modulus operation if an expression value is not in the range of the number of nodes available.

If the MERGE option is specified, the recordset must have been locally sorted by the sorts expressions. This avoids resorting.