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

Indexing strategies

I would imagine that by this time in the book, you would have expected some syntax and discussion of indexing strategies. Well, despite the heading for this section, that is not happening here. As I have mentioned before, there are things that Redshift has done that is different from other conventional relational databases. Based on the fact that the data is stored in a column store as well as the basic premise of eliminating I/O, there simply are no indexes. Now, before I just leave it at that, which really is just about it, you can build (optional) primary keys and (optional) column-level constraints. I call them optional because they are not enforced, and their only purpose is to inform the optimizer to help make better ...

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