What is a distribution key in redshift?

Redshift Distribution Keys (DIST Keys) determine where data is stored in Redshift. Clusters store data fundamentally across the compute nodes. Query performance suffers when a large amount of data is stored on a single node. ... This redistribution of data can include shuffling of the entire tables across all the nodes.

Related posts: