Standard data warehouse table setup. About a dozen numeric columns per table. The largest table (impressions) is 100x larger than the next biggest table (clicks), and 5000x larger than the smallest table (conversions). All tables sorted by date and by user id (SORTKEY), distributed by user id (DISTKEY). Two types of queries. (pardon the pseudo-SQL, see Appendix for full queries) SELECT keys, aggre
![AWS Redshift: How Amazon Changed The Game –](https://cdn-ak-scissors.b.st-hatena.com/image/square/f18beda7427bcb5e3792f6d5feadd69de1ff5482/height=288;version=1;width=512/https%3A%2F%2Fagkn.files.wordpress.com%2F2013%2F04%2Fday-by-day-loads-2.png)