云数据库 GaussDB-VACUUM:示例

时间：2025-02-12 15:06:01

云数据库 GaussDB

示例

  
       --创建SCHEMA。gaussdb=# CREATE SCHEMA tpcds;--创建表tpcds.reason。gaussdb=# CREATE TABLE tpcds.reason(  r_reason_sk      integer,  r_reason_id      character(16),  r_reason_desc    character(100));--向表中插入多条记录。gaussdb=# INSERT INTO tpcds.reason values(1,'AAAAAAAABAAAAAAA','reason 1'),(2,'AAAAAAAABAAAAAAA','reason 2');--在表tpcds.reason上创建索引。gaussdb=# CREATE UNIQUE INDEX ds_reason_index1 ON tpcds.reason(r_reason_sk);--对带索引的表tpcds.reason执行VACUUM操作。gaussdb=# VACUUM (VERBOSE, ANALYZE) tpcds.reason;--删除索引。gaussdb=# DROP INDEX ds_reason_index1 CASCADE;gaussdb=# DROP TABLE tpcds.reason;gaussdb=# DROP SCHEMA tpcds CASCADE;