O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required