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

Chapter 5. Querying Data

In this chapter, we will take a closer look at what you need to know to produce results from the data that you have worked so hard to load and organize in the database. We will also take a look at the management of the queries and tools that Redshift provides for understanding the database environment relative to these queries. As far as actual data retrieval goes, there are a few things to think about to optimize performance in the Redshift environment. We have already looked at how compression works, as well as the things you need to consider when creating your table with sort keys and distribution keys. This chapter will look more closely at how to monitor the performance of these tables and understand how to read and ...

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