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


Range of values

1 – value of max parallel degree



Display level


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.