max query parallel degree defines the number of worker processes to use for a given query. This parameter is relevant only if you do not want to enable parallelism globally. You must configure the number of worker processes to a value greater than zero, but max query parallel degree must be set to 1.
When max query parallel degree is set to a value greater than 1, queries are not compiled to use parallelism. Instead, you can specify parallel hints, using abstract plans to compile one or more queries using parallelism.
Use use parallel N to define how much parallelism is to be used for a given query. Alternatively, use create plan to specify the query and the number of worker processes to use for it.
