Sets the priority level at which requests from a connection are executed.

Allowed values

Critical, High, Above Normal, Normal, Below Normal, Low, Background

Default

Normal

Scope

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

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

Remarks

The value of this option cannot be set higher than the value of the max_priority option.

See also

• max_priority option [database]