Posted On: Aug 8, 2018
Amazon Redshift now enables Short Query Acceleration by default to speed up execution of short-running queries such as reports, dashboards, and interactive analysis. Short Query Acceleration uses machine learning to provide higher performance, faster results, and better predictability of query execution times.
Short-running queries can be delayed when entering a queue behind a long-running query like an extract, transform, and load (ETL) operation. Short Query Acceleration (SQA) uses machine learning to predict the execution time of a query, and move short-running queries to an express ‘short query’ queue. With SQA, short-running queries begin executing more quickly, and users see results sooner. The acceleration varies based on workload, though we have observed 3x improvements in short query performance for internal workloads.
In the latest release, SQA is enabled by default. To learn more, please refer to our documentation.
This feature is available in all regions where Amazon Redshift is available. For more information on where Amazon Redshift is available, see the Amazon Web Services region table.