Use max repartition degree to suggest a number of worker processes that the query processor can use to partition a data stream. You can set max repartition degree at the server or query level.
The value of max repartition degree is
a suggestion only; the query processor decides the optimal number.
max repartition degree is most useful when the tables being queried are not partitioned, but partitioning the resultant data stream may improve performance by allowing concurrent SQL operations.
For example, to set max repartition degree to 15 at the server level, enter:
sp_configure “max repartition degree”, 15
To set max repartition degree to 15 at the session level, enter:
set repartition_degree 15
The value of max repartition degree cannot exceed the current value of max parallel degree. Sybase recommends that you set the value of this parameter equal to or less than the number of CPUs or disk systems that can work in parallel.
