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

Take the Tuning Table Design Tutorial

Data loads are heavily influenced by table design, especially compression encodings and distribution styles. 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.