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

1

Range of values

1 – 255

Status

Static

Display level

Comprehensive

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.