ALTER WORKLOAD GROUP modifies a workload group and sets the number of concurrent SQL statements.
As long as the user has ALTER permission on the current database, the user can modify the workload group.
ALTER WORKLOAD GROUP wg_name USING RESOURCE POOL pool_name [ WITH ( ACT_STATEMENTS = count ) ];
Specifies the name of the workload group to be deleted.
A workload group must be unique in a database.
Value range: A string. It must comply with the naming convention rule.
Specifies the name of the resource pool.
Value range: A string that indicates an existing resource pool.
Specifies the number of concurrent SQL statements in the resource pool that the workload group belongs to.
Value range: An integer ranging from -1 to INT_MAX.
-- Create the resource pool named pool1: CREATE RESOURCE POOL pool1; -- Create the workload group named group1: CREATE WORKLOAD GROUP group1; -- Change the maximum number of concurrent SQL statements in workload group group1 to 10. The workload group is associated with the resource pool pool1. ALTER WORKLOAD GROUP group1 USING RESOURCE POOL pool1 WITH (ACT_STATEMENTS=10); -- Delete workload group group1 and resource pool pool1: DROP WORKLOAD GROUP group1; DROP RESOURCE POOL pool1;