vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/ddm/umn/ddm_08_0025.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

2.0 KiB
Raw Permalink Blame History

HINT-TABLE

HINTs are instructions within a SQL statement that tell the optimizer to execute the statement in a flexible way. This section describes how to use HINT syntax to delete data from a table.

Command Format:

/*+table=<physical_table_name>*/ TRUNCATE TABLE <table_name>

Description:

Deleting data in physical table <physical_table_name> in the current database shard does not affect other physical tables.

Example output before the table is deleted:

Example output after the table is deleted:

Hints are valid only for sharded tables.

Parent topic: TRUNCATE TABLE