Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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?