The goal of executing queries in parallel is to get the fastest response time, even if it involves more total work from the server.
To enable and control parallel processing, Adaptive Server provides these configuration parameters:
number of worker processes
max parallel degree
max resource granularity
max repartition degree
With the exception of number of worker processes, each of these parameters can be set at the server and the session level. To view the current session-level value of a parameter, use the select command. For example, to view the current value of max resource granularity, enter:
select @@resource_granularity
When set or viewed at the session level, these parameters
do not include “max.”
