云数据库 GAUSSDB-VACUUM:示例

时间:2024-11-02 18:53:07

示例

--在表tpcds.reason上创建索引。
openGauss=# CREATE UNIQUE INDEX ds_reason_index1 ON tpcds.reason(r_reason_sk);

--对带索引的表tpcds.reason执行VACUUM操作。
openGauss=# VACUUM (VERBOSE, ANALYZE) tpcds.reason;

--删除索引。
openGauss=# DROP INDEX ds_reason_index1 CASCADE;
openGauss=# DROP TABLE tpcds.reason;
support.huaweicloud.com/centralized-devg-v2-gaussdb/devg_03_0674.html