July 2018

Why would you do this?  In Redshift blocks are immutable – and are re-written completely – no partial block writes. […]

References to AWS Docs. For Redshift tuning table design distribution styles and distribution keys and much more… https://aws.amazon.com/blogs/big-data/amazon-redshift-engineerings-advanced-table-design-playbook-distribution-styles-and-distribution-keys/ https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/ https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-best-dist-key.html

diststyle and distkey combination define slice distributions diststyle defaults to “even” when not defined distkey has no default  

  Download Aginity Workbench Desktop Client Here – I believe it is a Windows only tool. http://www.aginity.com/redshift/ I had to

select * from stv_slices;