What is clustering or sort keys used for in a warehouse table?
- A Physically ordering data so related rows sit together and scans are reduced
- B Grouping users by role
- C Balancing server load
- D Compressing the schema
Answer
Physically ordering data so related rows sit together and scans are reduced
Combined with partitioning, good clustering can reduce the data scanned by orders of magnitude on selective queries.





