Database Design

Composite partitioned tables

• 

User Rating:  / 0

PoorBest 

Details

Parent Category: Articles

Created on Thursday, 18 March 2010 22:46

Last Updated on Friday, 25 October 2013 15:24

Published on Thursday, 18 March 2010 22:46

Written by Guy Lambregts

Hits: 3275

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