Skip to main content


Allow parallel processing instance-wide.


[SQL]    AutoParallel=n

n is either 1 or 0. The default value is 1.


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.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Execute queries in a single process to disable parallel processing.

To set the desired value for AutoParallel from the Terminal, use the SetOption(“AutoParallel”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change AutoParallel with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).

FeedbackOpens in a new tab