Performance Optimization
Amazon Redshift provides out-of-the-box performance for most workloads. It defaults table design choices such as compression, sort, and distribution key to AUTO and is able to learn from user workloads to automatically set up the right structure. For more information, see the Working with automatic table optimization page in the docs (https://docs.aws.amazon.com/redshift/latest/dg/t_Creating_tables.html). Amazon Redshift provides you with flexible controls that allow you to optimize performance and make alternative configuration choices whenever necessary. The sort, distribution key, and table encoding choices influence the performance of queries. In this chapter, we will discuss the optimization techniques to improve throughput. Also, we will take a deep dive into analyzing queries to understand the rationale behind the tuning exercise.
In this chapter, we will look into the following recipes:
- Configuring Amazon Redshift Advisor for provisioned...
