Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

max_parallel_statements option

Specifies the maximum number of statements listed inside the BEGIN PARALLEL WORK statement that the database server can execute in parallel at any time.

Allowed values

Integer

Default

0 (The database server executes as many statements in parallel as it chooses).

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No

Setting the max_parallel_statements option to 1 disables the parallel execution of the statements inside a BEGIN PARALLEL WORK statement.

The max_parallel_statements option respects the settings of the -gtc and -gta database server options and the ProcessorAffinity option of the sa_server_option system procedure.

Example

The following example sets the max_parallel_statements option to four.

SET TEMPORARY OPTION max_parallel_statements = 4;