28 | 03 | 2024
Latest Articles
Popular Articles

Database Design

Composite partitioned tables

User Rating:  / 0
PoorBest 

Composite partitioned tables

 

See also Partitioning Overview

 

Composite partitioning is the combination of partitioning and sub partitioning.


Two options are available in 10G


1. Range partition then sub partition by hash

2. Range partition then sub partition by list

 

Seven additional options are available in 11G


1. Range partition then sub partition by Range

2. Interval partition then sub partition by Range

3. Interval partition then sub partition by List

4. Interval partition then sub partition by Hash
 
5. List partition then sub partition by Range

6. List partition then sub partition by List

7. List partition then sub partition by Hash

 

Relevant data dictionary views

 

DBA_SUBPARTITION_TEMPLATES

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_MVIEW_DETAIL_SUBPARTITION