vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/ddm/umn/ddm_03_0040.html
Ru, Li Yi 4b09a03a51 ddm_umn 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2024-04-11 11:39:26 +00:00

1.4 KiB
Raw Permalink Blame History

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.
Parent topic: Supported SQL Statements