Specifies the session-specific number of RDBMS transfer threads available to the query optimizer.

Syntax

SET NUMBEROFRDBMSTRANSFERTHREADS threadCount;

Arguments

  • threadCount: The number of threads available for the query optimizer. Default is ‘1’. Provide a positive integer to specify a thread count. Specify ‘-1’ to return the number of threads for the session back to the system default.

Examples

SET NUMBEROFRDBMSTRANSFERTHREADS 3;
SELECT * FROM SYS.SYSSTATEMENTS;
SET NUMBEROFRDBMSTRANSFERTHREADS 1;