Purpose
Determines the percentage of rows in a join that are used by the optimizer to determine the number of skewed values used for split conditions when partial redistribution and partial duplication (PRPD) optimization is used.
A PRPD join strategy helps to minimize the impact of skew on join performance.
Field Group
Performance
Valid Range
1 through 100
Default
50
Changes Take Effect
After the DBS Control record has been written.
Related Topics
For more information on PRPD, see:
- PRPDMaxSkewedVals
- SQL Request and Transaction Processing