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

Take the Tuning Table Design Tutorial

Tutorial: Tuning Table Design walks you step by step through the process of choosing sort keys, distribution styles, and compression encodings, and shows you how to compare system performance before and after tuning.