When the hash facility for hash row partitioning is applied to a table with FIX hash partitioning, the performance of the following retrieval processes will decline while table rebalancing is being executed:

• Retrieval in which a condition is specified for a partitioning key
• Retrieval in which all partitioning keys are included in the columns specified as the GROUP BY clause

An index for which UNIQUE is specified cannot be updated while rebalancing is being executed.