In this tutorial, you learned how to optimize the design of your tables by applying table design best practices.
You chose sort keys for the SSB tables based on these best practices:
If recent data is queried most frequently, specify the timestamp column as the leading column for the sort key.
If you do frequent range filtering or equality filtering on one column, specify that column as the sort key.
If you frequently join a (dimension) table, specify the join column as the sort key.
You applied the following best practices to improve the distribution of the tables.
Distribute the fact table and one dimension table on their common columns
Change some dimension tables to use ALL distribution
You evaluated the effects of compression on a table and determined that using automatic compression usually produces the best results.
For more information, see the following links:
For your next step, if you haven't done so already, we recommend taking Tutorial: Loading Data from Amazon S3.