How does partitioning improve data warehouse performance? What partitioning strategies would you recommend, and what are the pitfalls?

Sample answer preview

Partitioning divides large tables into smaller, more manageable pieces based on the values of one or more columns. When queries filter on partition columns, the engine reads only relevant partitions instead of scanning the entire table, which can reduce query times dramatically.