medium10 pts · first answer countsdata-warehousingredshiftperformance
Distributing a small dimension
A Redshift dimension of 3,000 stores is joined to a billion-row fact distributed on order_id. Which distribution style for the stores table avoids moving data during the join?
Discussion 0
Join free to post in the discussion.
Related questions
- Partitioning a big tableData Engineer
- Kimball versus InmonData Engineer
- OLTP and OLAP workloadsData Engineer
- Why warehouses store columnsData Engineer
- Facts and dimensionsData Engineer
- Star versus snowflake schemaData Engineer
- Slowly changing dimension type 1Data Engineer
- ETL compared with ELTData Engineer