Database design

The singular best practice in database design considerations is for you to know your data. It is this knowledge that will allow you to make informed decisions on many items that will have a large impact. These impacts can be anything from the amount of storage you will be using (how much you compress your data) to how well queries perform. It is through your unique understanding of the data that you will pick the distribution keys, sort keys, and encoding specifications for compression. When you build tables in your database, provide as much information as possible about each column. Column-level constraints and primary keys are (although not enforced) important for the query planning process to understand what kind of data you ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.