max repartition degree configures the amount of dynamic repartitioning SAP ASE requires, which enables SAP ASE to use horizontal parallelism. However, if the number of partitions is too large, the system is flooded with worker processes that compete for resources, which degrades performance.
|
Summary Information |
|
|---|---|
|
Default value |
1 |
|
Range of values |
1 – value of max parallel degree |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
The value for max repartition degree enforces the maximum number of partitions created for these resources. If all of the tables and indexes are unpartitioned, SAP ASE uses the value for max repartition degree to provide the number of partitions to create as a result of repartitioning the data.