AutoParallel
Allow parallel processing instance-wide.
Synopsis
n is either 1 or 0. The default value is 1.
Description
When AutoParallel is enabled (n = 1), InterSystems SQL queries can use parallel processing to run more efficiently. In sharded environments, this means all queries are executed using parallel processing. In non-sharded environments, InterSystems SQL determines per-query whether to use parallel processing, based on the value of AutoParallelThreshold.
When this parameter is not enabled, all queries run in a single process.
If AdaptiveMode is enabled (set to 1) and AutoParallel is disabled, then Adaptive Mode overrides the AutoParallel setting and enables parallel processing.