We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

What's the mean statistics_type's value in the projection_column table? — Vertica Forum

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

HyeontaeJu

HyeontaeJu Vertica Customer ✭

September 2020 in General Discussion

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

0

Answers

Jim_Knicely - Select Field - Administrator

September 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
0

Leave a Comment