CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY

Changes the run-time priority of an active query.

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

  • Superuser: None
  • Non-superusers can only change the runtime priority of their own queries, and cannot raise the runtime priority of a query to a level higher than that of the resource pool.

Example

See Changing Runtime Priority of a Running Query.