REBAL operator

Operator name: REBAL

Represents:

The transferal of rows between SMP subagents for the purpose of rebalancing their workload. This operator is specific only to SMP environments.

Operations like table and index scans processed in parallel evenly distribute work among the SMP subagents by assigning them each a predetermined range of records for execution. Other operations, like data filtering and joins can cause data imbalance as the query executes. The optimizer restores this imbalance with the REBAL operator.