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

Unlock the full course today

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

Solution: Partitioning a table

Solution: 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

Solution: Partitioning a table

“

(upbeat music) - [Instructor] The problem with the definitions that we had for partitions is that there are gaps in the dates. The maximum date and the time range is not inclusive, so we need to have essentially some overlap between our partition definitions. In this case, the data for 24-1-8 and 24-1-16 are not assigned to our partition.

Contents