This website uses cookies to ensure you get the best experience.
Learn more.
Two large Redshift tables are frequently joined on customer_id. The join key has a well-distributed population, and the workload analysis shows network redistribution is a major cost. Which distribution approach should the engineer evaluate?
Published
- Use DISTSTYLE ALL for both very large tables without evaluating the replication cost.
- Collocate the tables using a suitable KEY distribution on customer_id, or evaluate automatic distribution against the workload.
- Choose unrelated distribution keys for the two tables and expect identical column names in the query to collocate the data.
- Use a constant distribution-key value for every row to ensure all joins use one slice.
Comments — 0
Sign in to comment