**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.