max query parallel degree

(Used when SAP ASE is in compatibility mode) Defines the number of worker processes to use for a given query.

Summary Information

Default value


Range of values

1 – 255



Display level


Required role

System administrator

Configuration group

Query Tuning

This parameter is relevant only if you do not want to enable parallelism globally. The value for number of worker process cannot be less than the value for max query parallel degree.

See Performance and Tuning Series: Query Processing and Abstract Plans > Parallel Query Processing.

For more information about compatibility mode, see the Migration Technology Guide.