Keeping up-to-date statistics on tables at scale

kxukxu Administrator
in General Discussion

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

Tagged:

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...