Enable Intra-Partition Parallelism (intra_parallel)

Configuration Type

Database manager

Applies To

• Database server with local and remote clients
• Database server with local clients
• Partitioned database server with local and remote clients
• Satellite database server with local clients

Parameter Type

Configurable

Default [Range]

NO (0) [SYSTEM (-1), NO (0), YES (1)]

A value of -1 causes the parameter value to be set to "YES" or "NO" based on the hardware on which the database manager is running.

Related Parameters

Maximum Query Degree of Parallelism (max_querydegree)

This parameter specifies whether the database manager can use intra-partition parallelism.

Some of the operations that can take advantage of parallel performance improvements when this parameter is "YES" include database queries and index creation.

Note:

If you change this parameter value, packages may be rebound to the database. If this occurs, a performance degradation may occur during the rebinding.