Question: what is distribution key in redshift?
Answer: Redshift Distribution Keys (DIST Keys) determine where data is stored in Redshift. ... Query performance suffers when a large amount of data is stored on a single node. The query optimizer distributes less number of rows to the compute nodes to perform joins and aggregation on query execution.