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

时间:2024-11-02 18:52:19

语法格式

  • 回收空间并更新统计信息,对关键字顺序无要求。
    VACUUM [ ( { FULL | FREEZE | VERBOSE | {ANALYZE | ANALYSE }} [,...] ) ]
        [ table_name [ (column_name [, ...] ) ] [ PARTITION ( partition_name ) | SUBPARTITION ( subpartition_name ) ] ];
  • 仅回收空间,不更新统计信息。
    VACUUM [ FULL [COMPACT] ] [ FREEZE ] [ VERBOSE ] [ table_name 
    [ PARTITION ( partition_name )  | SUBPARTITION ( subpartition_name ) ] ];
  • 回收空间并更新统计信息,且对关键字顺序有要求。
    VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] { ANALYZE | ANALYSE } [ VERBOSE ] 
        [ table_name [ (column_name [, ...] ) ] ] [ PARTITION ( partition_name )];
support.huaweicloud.com/centralized-devg-v2-gaussdb/gaussdb_42_0508.html