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: Partitioning a table

Challenge: Partitioning 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: Partitioning a table

“

(upbeat music) - [Instructor] Let's consider partitioning a table by a time range. Let's imagine we create a table called sensor metrics, which has several attributes including a sensor ID, a measurement date, temperature, humidity, and pressure. Also, we want to partition the by range using measure date. Here are some definitions of partitions. Now, as you look at these, I want you to consider what might be a problem with the definitions that we have here.

Contents