Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Tuning Query Performance

Amazon Redshift uses queries based on structured query language (SQL) to interact with data and objects in the system. Data manipulation language (DML) is the subset of SQL that you use to view, add, change, and delete data. Data definition language (DDL) is the subset of SQL that you use to add, change, and delete database objects such as tables and views.

Once your system is set up, you will 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.

To understand how Amazon Redshift processes queries, use the Query Processing and Analyzing and Improving Queries sections. Then you can apply this information in combination with diagnostic tools to identify and eliminate issues in query performance.

To identify and address some of the most common and most serious issues you are likely to encounter with Amazon Redshift queries, use the Troubleshooting Queries section.