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

时间：2024-11-13 14:46:42

云数据库 GAUSSDB V

语法格式

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

VACUUM [ ( { FULL | FREEZE | VERBOSE | { ANALYZE | ANALYSE } } [, ... ] ) ]
    [ table_name [ (column_name [, ... ] ) ] [ PARTITION ( partition_name ) | SUBPARTITION ( subpartition_name ) ] ]
    [ OFFLINE | [ ONLINE [ WITH ( { online_parameter = value } [, ... ] ) ] ] ];

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

VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ]
    [ table_name [ PARTITION ( partition_name ) | SUBPARTITION ( subpartition_name ) ] ]
    [ OFFLINE | [ ONLINE [ WITH ( { online_parameter = value } [, ... ] ) ] ] ];

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

VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] { ANALYZE | ANALYSE } [ VERBOSE ]
    [ table_name [ ( column_name [, ... ] ) ] ] [ PARTITION ( partition_name ) ]
    [ OFFLINE | [ ONLINE [ WITH ( { online_parameter = value } [, ... ] ) ] ] ];

上一篇：云数据库 GAUSSDB-VACUUM:示例

下一篇：云数据库 GAUSSDB-VACUUM:注意事项