Amazon Redshift Best Practices
This chapter presents best practices for designing tables, loading data into tables, and writing queries.
Amazon Redshift is not the same as other SQL database systems. To fully realize the benefits of the Amazon Redshift architecture, you must specifically design, build, and load your tables to leverage massively parallel processing, columnar data storage, and columnar data compression. If your data loading and query execution times are longer than you expect, or longer than you want, you might be overlooking key information.
If you are an experienced SQL database developer, we strongly recommend that you review this chapter before you begin developing your Amazon Redshift data warehouse.
If you are new to developing SQL databases, this is not the best place to start. We recommend that you begin by reading Getting Started Using Databases and trying the examples yourself.
This chapter provides an overview of the most important development principles, along with specific tips, examples, and best practices for implementing those principles. No single practice can apply to every application. You should evaluate all of your options before finalizing a database design. For more information, see Designing Tables, Loading Data, Tuning Query Performance, and the reference chapters.