All Products
Search
Document Center

AnalyticDB:Specify a resource group to execute queries

Last Updated:Aug 12, 2024

AnalyticDB for MySQL Data Warehouse Edition allows you to specify a resource group to execute queries by adding a hint to SQL statements or associating the resource group with a database account. If you do not specify a resource group to execute queries, the USER_DEFAULT resource group is used. This topic describes how to specify a resource group when you submit SQL queries.

Use JDBC to submit SQL queries

You can use one of the following methods to specify a resource group to execute queries:

  • Add a hint to SQL statements. Syntax: /*+resource_group=resourceGroupName*/.

  • Associate a resource group with a database account. For more information, see Associate with or disassociate from a database account.

  • If you do not specify a resource group, the USER_DEFAULT resource group is used.

If you specify multiple resource groups by using the preceding methods, the resource groups take effect in the following order based on priority: hint-based resource group, associated resource group, and default resource group.