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
1 Answers
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).
Related