Ravi Sir's Cards › AWS
What does SORTKEY do?
This interview card answers: What does SORTKEY do? Physically orders data so zone maps skip irrelevant blocks on filter columns. Time columns are common sort keys. WHERE order_date = today skips old blocks.
Read card text
What this card says
What it is
Physically orders data so zone maps skip irrelevant blocks on filter columns.
SORTKEY
Why it matters
Time columns are common sort keys.
How / example
WHERE order_date = today skips old blocks.