Introducing the topic:
In list partitioning, the database uses a list of discrete values as the partition key for each partition. You can use list partitioning to control how individual rows map to specific partitions. By using lists, you can group and organize related sets of data when the key used to identify them is not conveniently ordered.
Here an example:
1. This example shows how the index works
Assume that you create list_sales as a list-partitioned table using the following statement. The channel_id column is the partition key.
Table Partition HIGH_VALUE
Table Partition MEDIUM_VALUE
Table Partition LOWER_VALUE
Download the script:
LIST-PARTITIONED TABLE – script.sql
Around the scenery:
– Link to others partition: INTERVALPARTITIONING (article of September)
– Concept of Partitioning Partitioning enables tables and indexes to be subdivided into individual smaller pieces. Each piece of the database object is called a partition. A partition has its own name, and may optionally have its own storage characteristics. From the perspective of a database administrator, a partitioned object has multiple pieces that can be managed either collectively or individually.
Out of scope:
– Range-Partitioned Tables and Global Indexes
– Hash-Partitioned Tables and Global Indexes
– Reference-Partitioned Tables
– Composite Partitioned Tables