parallel_degree_limit

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

Examples

set parallel_degree_limit =256;

set global parallel_degree_limit =256;