Previous Topic Next topic Print topic


DEGREE

Specifies whether or not the query is to be executed using I/O parallel processing.

Syntax:

DEGREE={1 | degree-of-parallelism | ANY}
NODEGREE

Parameters:

1 Prohibits parallel I/O operations
degree-of-I/O-parallelism Specifies the degree of parallel I/O operations, a value between 2 and 32767 (inclusive)
ANY Allows parallel I/O operations.

Properties:

Default: NODEGREE
Previous Topic Next topic Print topic