Skip to main content
Question

What are some best practices for updating table statistics?

  • Apr 1, 2020 1:49 PM UTC
  • 1 reply
  • 8 views
rjs_docs

Could you please provide some best practices for how often I should update table statistics?
@bat @rbankula

From Optimizing Query Performance and Resource Pool Tuning.

    1 reply

    JoeGonzalezVertDBA

    I follow the recommendations here pretty closely
    https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/Statistics/BestPracticesForStatisticsCollection.htm

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement