Sorting Tables for Redshift

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Developing the Physical Model

The Sort tab of the Table Editor for the Amazon Redshift platform allows you to create the SORTSTYLE and SORTKEY clauses for a table.

The Sort Keys section allows you to choose columns to be used as sort keys. Once a sort key is added, the Sort Style dropdown is enabled and provides the choice of whether it is a COMPOUND sort key or INTERLEAVED.

See Also