(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.