Database Design
Composite partitioned tables
User Rating: / 0
- 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: 3288
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