CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY

Changes the run-time priority of an active query.

Note: This function replaces deprecated function CHANGE_RUNTIME_PRIORITY.

Syntax

CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY(transaction-id, 'value')

Parameters

transaction‑id Identifies the transaction, obtained from the system table SESSIONS.
value

The RUNTIMEPRIORITY value: HIGH, MEDIUM, or LOW.

Privileges

Example

See Changing Runtime Priority of a Running Query.