max repartition degree

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.