Question

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

Forum|Forum|6 years ago
September 1, 2020
1 reply
4 views

Forum|alt.badge.img

+2

HyeontaeJu
Participating Frequently

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

Forum|alt.badge.img

+2

Jim_Knicely
Participating Frequently
Forum|Forum|6 years ago
September 1, 2020

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

Like