The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
ANALYZE_STATISTICS on single node cluster
We have a single node Vertica server, and we had never run ANALYZE_STATISTICS on it before. For a testing, I ran ANALYZE_STATISTICS, but I didn't see any performance improvements (virtually no changes) on our queries after ANALYZE_STATISTICS. I know running ANALYZE_STATISTICS is supposed to improve the system performance, but not sure why it did not improve for us. Could it be our queries, our data or that we are running on a single node?