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

Unlock the full course today

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

Partition by list

Partition by list - SQL Tutorial

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

Start my 1-month free trial Buy for my team

Partition by list

“

- [Instructor] Partitioning by list is a type of horizontal partitioning. Data is divided among partitions, based on a partition key. In this case, the partition values are defined in a list of values. Now, there is a partition key, which takes values from a list of partition values. The partition bounds, are the list of values allowed in the partition. And, like other forms of horizontal partitioning, each partition can have its own indexes, constraints, and defaults. Here's a product catalog example. In this products table, we have an ID, name, short and long description, and a product category. And the partition key is the product category. Notice, that when we define the partition table, we have to list the values of the partition key, that will be allowed in that partition. We use list partitioning, when data logically groups into subgroups, based on the partition key values. For example, we could have a…

Contents