hard20 pts · first answer countsredshiftperformance

Choosing a Redshift DISTKEY

In Amazon Redshift, two large tables, orders and order_items, are joined on order_id in most queries and the join is slow. Which distribution design helps most?

A.Distribute both tables with DISTKEY(order_id), so matching rows sit on the same slice and need no redistributionB.Use DISTSTYLE ALL on both large tablesC.Use DISTSTYLE EVEN on both tablesD.Distribute orders by customer_id and items by sku

← Clustering for two filter columns Rows missed by a strict watermark →