云数据库 GAUSSDB-VACUUM:语法格式

时间：2023-11-15 14:50:05

云数据库 GAUSSDB

回收空间并更新统计信息，对关键字顺序无要求。

1 2	VACUUM [ ( { FULL \| FREEZE \| VERBOSE \| {ANALYZE \| ANALYSE }} [,...] ) ] [ table_name [ (column_name [, ...] ) ] ] [ PARTITION ( partition_name ) ];

仅回收空间，不更新统计信息。

1	VACUUM [ FULL [COMPACT] ] [ FREEZE ] [ VERBOSE ] [ table_name ] [ PARTITION ( partition_name ) ];

回收空间并更新统计信息，且对关键字顺序有要求。

1 2	VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] { ANALYZE \| ANALYSE } [ VERBOSE ] [ table_name [ (column_name [, ...] ) ] ] [ PARTITION ( partition_name ) ];