Vertica Tip: Analyzing Table Statistics by Column
Posted: Wed Sep 12, 2018 6:59 pm
The ANALYZE_STATISTICS function collects and aggregates data samples and storage information from all nodes that store projections associated with the specified table. On a very large wide table, it takes a significant amount of time to gather those statistics.
In many situations only a few columns in the table are modified as part of an ETL/ELT process. In these cases instead of reanalyzing all of the table’s columns, you can analyze just the updated columns, reducing the ANALYZE_STATISTICS function’s run time!
Find out how here:
https://forum.vertica.com/discussion/23 ... -by-column
In many situations only a few columns in the table are modified as part of an ETL/ELT process. In these cases instead of reanalyzing all of the table’s columns, you can analyze just the updated columns, reducing the ANALYZE_STATISTICS function’s run time!
Find out how here:
https://forum.vertica.com/discussion/23 ... -by-column