After loading a table with significant volume >50 % the recommendation as per vertica manuals is to run analyze_statistics which take 10 pct sample. Is this enough or should we run analyze_histogram. What should be ideal sample percent (1-100) ? Also does vertica automatically run analyze_statistics after purge /delete or on any other trigger?
analyze_statistics vs analyze_histogram
+2
Pretty sure analyze_histogram has been deprecated and analyze_statistics has been updated. I'll take a look at the docs and see what I can find.
So, not exactly deprecated, but take a look and you decide.
+2we are using vertica 7.1 hence using analyze_histogram
+2Analyze_statistics should suffice and to you question "does vertica automatically run analyze_statistics after purge /delete or on any other trigger" , answer is no. You have to issue analyze_statistics, if there are significant changes.
Analyze_Statistics and Analyze_Histogram do the exact same thing except Analyze_Histogram gave you the ability of changing the fixed 10% to any other percentage in Versions through 7.2. After 7.2, Analyze_Statistics has the percent option. And as @skamat mentioned above, you should be fine with Analyze_Statistics and no it does not automatically run, you must instruct Vertica to run it. It is recommended you run it any time your data has changed significantly as you mentioned.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
