The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.
Questions about analyze_statistics
We have a database where data is inserted continuously and older data is deleted regularly. I think running ANALYZE_STATISTICS may help with the query performance. A couple of questions on ANALYZE_STATISTICS : 1. Does Vertica update statistics automatically based on the states of the data in the database? If so, how does it do it? 2. If we schedule to update statistics regularly, what would be the best practice to do that, such as how to determine when to run it, how to schedule it and to run it, etc.? Any sample scripts can be used to determine when statistics needs to be updated? Our system is up at all times, and there could be queries running against the database at any given time, ideally, updating the statistics should not affect the system much.