Keeping up-to-date statistics on tables at scale
kxu
Employee
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