Ravi Sir's Cards › AWS
What does DISTKEY do?
This interview card answers: What does DISTKEY do? Co-locates rows with the same key on the same node to speed joins. Pick a high-cardinality join key used often. Fact and dim both DIST on customer_id.
Read card text
What this card says
What it is
Co-locates rows with the same key on the same node to speed joins.
DISTKEY
Why it matters
Pick a high-cardinality join key used often.
How / example
fact and dim both DIST on customer_id.