Question

A data engineering team runs an Amazon Redshift cluster storing a 4-billion-row fact table. Storage costs are rising and query scans are slow. The table was created without specifying column encodings, and most columns currently use RAW encoding. The team wants Redshift to determine the most effective compression for each column based on the actual data. Which approach should they use?

Accepted Answer

Run the ANALYZE COMPRESSION command on the table to get recommended encodings, then recreate the table with those encodings and reload the data

Answer

Run VACUUM FULL on the table to automatically apply optimal column compression in place

Answer

Increase the number of cluster nodes so each node stores less data, reducing the need for compression

Answer

Change the table's distribution style to EVEN so that compression is applied uniformly across slices