Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 148 of 220
Parameter type |
Boolean |
Default value |
|
Parameter class |
Dynamic: |
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.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|