数据仓库服务 GAUSSDB(DWS)-ANALYZE | ANALYSE:示例

时间:2024-01-16 08:48:20

示例

  • 使用ANALYZE语句更新表customer_info统计信息:
    1
    ANALYZE customer_info;
    
  • 使用ANALYZE VERBOSE语句更新表customer_info统计信息,并输出表的相关信息:
    1
    2
    3
    4
    5
    ANALYZE VERBOSE customer_info;
    INFO:  analyzing "cstore.pg_delta_3394584009"(cn_5002 pid=53078)
    INFO:  analyzing "public.customer_info"(cn_5002 pid=53078)
    INFO:  analyzing "public.customer_info" inheritance tree(cn_5002 pid=53078)
    ANALYZE
    
support.huaweicloud.com/sqlreference-dws/dws_06_0245.html