As Amazon Redshift is a columnar data warehouse storing each columns in a separate file, you can specify a distribution key and sort key for a very large dimensional table to optimize the performance. You can also specify if the column is a primary key or foreign key to uniquely identify a record in the Amazon Redshift table.