REBAL operator (for DB2 for Linux, UNIX, and Windows, Version 10.1)

This operator represents the transferal of rows between subagents in symmetric multiprocessor (SMP) environments.

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.


Feedback