ANALYZE_STATISTICS

ANALYZE_STATISTICS collects and aggregates data samples and storage information from all nodes on which a projection is stored, then writes statistics into the catalog so that they can be used by the query optimizer. Without these statistics, the query optimizer would assume uniform distribution of data values and equal storage usage for all projections.

Syntax

SELECT ANALYZE_STATISTICS ( 'projection' )

Semantics