HP vertica收集表的统计信息

一.通过PROJECTION_COLUMNS的statistics_type查看表的列的统计信息类型,和收集时间

SELECT projection_name,projection_column_name,
       statistics_type,statistics_updated_timestamp,
       column_position
FROM PROJECTION_COLUMNS 

where table_schema='FDL' and table_name = 'FDL_T01_XXX';

--statistics_type最好为full

二.通过PROJECTIONS的HAS_STATISTICS判断表是否有统计信息

ELECT projection_basename,projection_name
       segment_expression,segment_range,verified_fault_tolerance,
       HAS_STATISTICS,is_segmented
FROM PROJECTIONS 

where projection_schema='FDL' and projection_basename='FDL_T01_XXX';

--同样可以查看分段的类型,分布

三.通过PROJECTION_STORAGE的row_count,used_bytes等统计信息,判断统计信息是否准确

select NODE_NAME,projection_name,projection_column_count,
   row_count,used_bytes
from PROJECTION_STORAGE
where ANCHOR_TABLE_SCHEMA='FDL' and ANCHOR_TABLE_NAME='FDL_T01_XXX'

order by projection_name,node_name;

四.收集单表统计信息

select ANALYZE_STATISTICS('FDL.FDL_T01_XXX');

五.批量收集表的统计信息

select 'select ANALYZE_STATISTICS('''||(table_schema|