Amazon Redshift now updates table statistics by running ANALYZE automatically

Posted on: Jan 18, 2019

Analyze operations now run automatically on your Amazon Redshift tables in the background to deliver improved query performance and optimal use of system resources.

Amazon Redshift's sophisticated query planner uses a table's statistical metadata to choose the optimal query execution plan for better query performance. The analyze operation generates or updates the table statistics. With this update, you no longer need to explicitly run the ANALYZE command. If you do run it as part of your extract, transform, and load (ETL) workflow, automatic analyze skips tables with up-to-date statistics. Similarly, an explicit ANALYZE skips tables with up-to-date table statistics.

For more information, see Automatic Analyze in the Amazon Redshift Database Developer Guide.

Automatic Analyze is now available with the release version 1.0.5671 or higher in all AWS commercial regions. Refer to the AWS Region Table for Amazon Redshift availability.