LIST-PARTITIONED

LIST-PARTITIONED

7 Febbraio 2018 Oracle Database 0

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.

check partition:

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

 

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *