Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Keeping up-to-date statistics on tables at scale

I'm having some trouble keeping my statistics up-to-date on tables at scale. Does Vertica have a way to run full stats after DDL operations? Or do we need to manually run stats to keep them current? For example, this is what we run
Select analyze_statistics('schema.tableA');
Right now we're having our application run this command after certain DDL operations. What's the best way to manage these stats and keep them updated on thousands of tables?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.