Redshift

Question 1

Update table statistics

Answer 1

ANALYZE table_name

Question 2

Distribution styles

Answer 2

Key: Dist. according to values in one column

Even: Rows dist. round robin style

All: Entire table copied to each node

Question 3

Sort keys

Answer 3

1 or more columns. Stored on disk in sorted order

Question 4

Debug query

Answer 4

EXPLAIN plan
Set STATISTICS IO ON
Set STATISTICS TIME ON