Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Updating table statistics?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
You can have Vertica build ANALYZE_STATISTICS commands to analyze stats on projections that do not have stats... Then have crontab run them.
Simple Example:
So your crontab entry might run once a day like this:
00 00 * * * /home/dbadmin/scripts/analyze_stats.sh > /home/dbadmin/scripts/analyze_stats.out 2>&1
Where the analyze_stats.sh script looks like this: