parallel_degree_limit

parallel_degree_limit specifies the maximum degree of parallelism (DOP) that the optimizer can select when the Auto DOP policy is used.

Sample code

set parallel_degree_limit =256;

set global parallel_degree_limit =256;