From the course: Advanced SQL for Query Tuning and Performance Optimization

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge: Choosing how to partition a table

Challenge: Choosing how to partition a table - SQL Tutorial

From the course: Advanced SQL for Query Tuning and Performance Optimization

Start my 1-month free trial Buy for my team

Challenge: Choosing how to partition a table

“

(bright digital music) - [Instructor] Let's imagine you have a table that you use to analyze sales performance of multiple products over time. Now you commonly need to compare sales in a month to the sales in that same month, but from the previous year. Now, queries may include multiple products, but they're always limited to just a single month that we look at. So what's a good way to partition this data?

Contents