Determines the maximum number of skewed values in a join that should be considered by the optimizer to determine a partial redistribution and partial duplication (PRPD) optimization plan.
A PRPD join strategy helps to minimize the impact of skew on join performance.
Field Group
Performance
Valid Range
1 through 500
Default
50
Changes Take Effect
After the DBS Control record has been written.
Related Information
- PRPDSkewPct
- SQL Request and Transaction Processing, B035-1142