Help Center/Distributed Database Middleware/User Guide/SQL Syntax/Supported SQL Statements/Specifying a Shard Using a Hint When Executing a SQL Statement
Updated on 2022-09-16 GMT+08:00
View PDF

Specifying a Shard Using a Hint When Executing a SQL Statement

Command Format:

/*+db=<physical_db_name>*/ <your query>;

Description:

Specify a shard by configuring <physical_db_name> and execute a SQL statement on the shard.

Example:

/*+db=test_0000*/ select * from t1;

Restrictions:

  • The hint is valid only for SELECT, DML, and TRUNCATE statements.
  • The hint works only under the text protocol, rather than the Prepare protocol.