analyze_statistics vs analyze_histogram
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?