Summary information |
|
|---|---|
Default value |
1 |
Range of values |
1 – 255 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Query Tuning |
Used when Adaptive Server is in compatibility mode. 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. The value for number of worker process cannot be less than the value for max query parallel degree.
See Chapter 5, “Parallel Query Processing,” in the Performance and Tuning Series: Query Processing and Abstract Plans.
For more information about compatibility mode, see the Migration Technology Guide.
