Automatic table optimization is a self-tuning capability in Amazon Redshift that automatically optimizes the design of tables by applying sort and distribution keys.

Initially, a table has no distribution ... in size, Amazon Redshift applies the optimal distribution keys and sort keys. Optimizations are applied within hours after a minimum number of queries are run....

October 6, 2021 - More recently, Amazon Redshift Advisor provided suggestions, but these still had to be manually implemented. At AWS re:Invent 2020, Amazon Redshift announced a new feature to automate this process: automatic table optimization (ATO).

April 20, 2022 - If tables that are frequently accessed with complex patterns are missing statistics, Amazon Redshift Advisor creates a critical recommendation to run ANALYZE. If tables that are frequently accessed with complex patterns have out-of-date statistics, Advisor creates a suggested recommendation to run ANALYZE. The following screenshot shows a table statistics recommendation. Auto WLM simplifies workload management and maximizes query throughput by using ML to dynamically manage memory and concurrency, which ensures optimal utilization of the cluster resources

Amazon Redshift hosts a set of automated features, termed collectively as autonomics, that enhance performance, reduce manual maintenance, and optimize resource usage. Autonomics leverage machine learning and background processes to manage database operations efficiently, automating many routine ...

March 19, 2026 - Once your system is set up, you typically work with DML the most, especially the SELECT command for retrieving and viewing data. To write effective data retrieval queries in Amazon Redshift, become familiar with SELECT and apply the tips outlined in Amazon Redshift best practices for designing tables to maximize query efficiency.

Amazon Redshift stores your data on disk in sorted order according to the sort key. The Amazon Redshift query optimizer uses sort order when it determines optimal query plans. To use sort keys effectively, we recommend that you do the following: Keep the table sorted as much as possible.

December 9, 2020 - Amazon Redshift, the most widely used cloud data warehouse, announces general availability of Automatic Table Optimization, a new self-tuning capability that optimizes the physical design of tables by automatically setting sort and distribution keys to improve query speed.

March 19, 2026 - As you plan your database, certain key table design decisions heavily influence overall query performance. These design choices also have a significant effect on storage requirements, which in turn affects query performance by reducing the number of I/O operations and minimizing the memory ...

September 19, 2024 - Tip: Evaluate whether the benefits of RA3 nodes‘ scalability justify the additional expense for your specific use case. When setting up large tables in Amazon Redshift, choosing an optimal sort key is crucial for enhancing query performance.

1 month ago - This optimization reorders and efficiently adjusts the data blocks to be read based on the ORDER BY column's min/max values, maintaining only the K most qualifying rows in memory. When the ORDER BY column is sorted or partially sorted, Amazon Redshift now processes only the minimal data blocks ...

December 16, 2020 - Redshift Automatic Table Optimization (ATO) uses the same mechanism as Redshift Advisor for sort and distribution key recommendations. With ATO, all recommendations are recorded in the SVV_ALTER_TABLE_RECOMMENDATIONS system table.

September 16, 2025 - This improvement occurs because you're reducing data volume early and giving the query planner cleaner optimization opportunities. The staging approach also makes query debugging easier when analysts need to validate intermediate results. Traditional row-based approaches fail in Amazon Redshift analytical scenarios where ad-hoc queries scan millions of rows accessing limited column subsets. Default compression settings leave performance gains unrealized for wide tables (20+ columns) exceeding 100M rows. AWS columnar compression documentation confirms dramatic I/O reduction for analytical workloads accessing column subsets.

“The Amazon Redshift materialized view auto query rewrite feature reduced dashboard load times from 8 minutes to just · 500 ms. The best part is that this is completely transparent for Tableau and the business user.”

This distribution style is an especially optimal choice when tables aren’t involved in joins. Conversely, joins involving rows matched by tables on different nodes increases network traffic and · diminishes query performance. The exception is when joining from tables using EVEN to tables using an · ALL distribution style since the second table’s records are already available on each node in the cluster. ... Absent another distribution style specification, Amazon Redshift will use an automatic distribution.

AWS · Amazon Redshift Autonomics · Automate your data warehouse · performance tuning · © 2023, Amazon Web Services, Inc. or its affiliates. Agenda · • · The need for data warehouse tuning automation · • · Redshift architecture · • · Automatic Table Optimization ·

Describes how to use query plan and query summary information to tune query performance.

November 25, 2025 - As a best practice, we recommend running ANALYZE on any tables with a “stats off” percentage greater than 10%. Amazon Redshift is a distributed, shared-nothing database that scales horizontally across multiple nodes. Query execution time is very tightly correlated with: ... Below is an example of a poorly written query, and two optimizations to make it run faster.

October 19, 2025 - Use Amazon Redshift's automatic table optimization features, such as automatic table sort and distribution key optimization, to continuously improve table design based on workload patterns.

October 9, 2024 - Let's recap the key techniques for Amazon Redshift query optimization: ... Smart table design reduces skew and improves compression. Better loading means faster input and less disk usage.