|Oracle9i Database Reference
Release 1 (9.0.1)
Part Number A90190-02
Initialization Parameters, 148 of 220
|Range of values||
PARALLEL_BROADCAST_ENABLED lets you improve performance of hash and merge join operations in which a very large join result set is joined with a very small result set (size being measured in bytes, rather than number of rows).
When this parameter is set to
true, the optimizer can choose to copy all the source rows of the small result set and broadcast a copy to each cluster database that is processing some rows of the larger set.