medium10 pts · first answer countsdata-warehousingredshiftperformance

Redshift sort key for date filters

Most Redshift queries on a large sales table filter on a recent sale_date range. What does making sale_date the sort key do?

A.It spreads rows evenly across nodesB.It removes the need for VACUUMC.It lets zone maps skip blocks outside the date rangeD.It makes joins on sale_date avoid network traffic

Discussion 0

Join free to post in the discussion.

Redshift sort key for date filters

Discussion 0

Related questions