Oracle Partitioning分区技术历年新特性回顾

原创

maclean_007 2011-12-27 20:46:56 ©著作权

文章标签 Oracle 数据库 Composite Partitioning 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者maclean_007的原创作品，请联系作者获取转载授权，否则将追究法律责任

Partitioning分区是Oracle一种重要的处理大量数据的特性，从Oracle 8开始引入range partition范围分区，到现在11g中出现的Interval Partition、REF Partitions、Partition Advisor等new feature，分区技术在一步步走向成熟。

Oracle Partitioning分区技术历年新特性回顾_Composite

下表列出了从Oracle 8到11g的各历史版本中出现的分区特性：

	Core functionality	Performance	Manageability
Oracle8	Range partitioning	“Static” partition pruning	Basic maintenance operations: add, drop, exchange
Oracle8	Global range indexes	“Static” partition pruning	Basic maintenance operations: add, drop, exchange
Oracle8i	Hash and composite range-hash partitioning	Partition-wise joins	Merge operation
Oracle8i	Hash and composite range-hash partitioning	“Dynamic” pruning	Merge operation
Oracle9i	List partitioning		Global index maintenance
Oracle9i R2	Composite range-list partitioning	Fast partition split
Oracle10g	Global hash indexes		Local Index maintenance
Oracle10g R2	1M partitions per table	“Multi-dimensional” pruning	Fast drop table
Oracle Database 11g	More composite choices		Interval Partitioning
	REF Partitioning		Partition Advisor
	Virtual Column Partitioning

复合分区(Composite Partitioning)最早在版本8i中被引入(Range-Hash)，是一种二维的模式分区技术；在11g中进一步扩展了Composite Partitioning，11g 支持RANGE-RANGE、 RANGE-LIST、LIST-LIST、LIST-HASH等几种模式。其中RANGE-RANGE是我们久违了的，很多初学分区概念的同学都会惊讶于11g以前居然没有RANGE-RANGE分区可用。