PRIORITY GROUPS

Purpose

Use this statement to create, alter, and drop of priority groups.

Prerequisite

You need to have the system privilege MANAGE PRIORITY GROUPS.

Syntax

create_priority_group::=

Create Priority Group Statement

alter_priority_group::=

Alter Priority Group Statement

drop_priority_group::=

Drop Priority Group Statement

Usage Notes

  • Details about priority groups is available in Priorities.
  • The weight of a priority group has to be between 1 and 1000.

Examples

CREATE PRIORITY GROUP "marketing" WITH WEIGHT = 50;
ALTER PRIORITY GROUP "marketing" SET WEIGHT = 150;
DROP PRIORITY GROUP "marketing";