Deprecated. Limits impact on the performance of connections other than the current connection.

Allowed values

On, Off

Default

Off

Scope

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

If you set this option temporarily, that setting applies to the current connection only. Different connections under the same user ID can have different settings for this option.

Intra-query parallelism is not used for connections with background_priority set to on. See Parallelism during query execution.

Remarks

Setting this option to On causes requests to execute at the Background priority level. When this option is set to Off, requests execute at the value specified by the Priority option.

See also

• priority option [database]
• max_priority option [database]