Question

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

6 years ago
Sep 1, 2020 2:17 AM UTC
1 reply
7 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
6 years ago
Sep 1, 2020 2:32 AM UTC

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