Create an index on a materialized view in Amazon Redshift

Question

How do you create a index on a materialized view in Amazon Redshift? I see the documentation for creating a materialized index, but there is no indication on whether or not indexes are supported: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-create-sql-command.html

Answer 1

Redshift doesn't have indexes.

You can configure distribution keys and sort keys, which provide some of the functionality of indexes.

A traditional B-Tree index would rarely be appropriate for the sorts of queries that you'd use Redshift for (which tend to be all-rows joins between large tables).