Operations like table and index scans, processed in parallel, evenly distribute work among SMP subagents by assigning each agent a predetermined range of records for execution. Other operations, like data filtering and joins, can cause data to become imbalanced as a query executes. The DB2 optimizer restores the balance with the REBAL operation.