What's the mean statistics_type's value in the projection_column table?

HyeontaeJu

What's the mean statistics_type's value in the projection_column table?
I can see the value FULL, NONE, ROWCOUNT

Jim_Knicely

The Vertica online documentation is great place to look for answers

For example:

https://www.vertica.com/docs/Latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PROJECTION_COLUMNS.htm

STATISTICS_TYPE: The type of statistics the column contains. Valid Values:

• NONE: No statistics
• ROWCOUNT: Set by ANALYZE_ROW_COUNT
• FULL: Set by running ANALYZE_STATISTICS