我们要介绍的第一种类型是区间分区表(range partitioned table)。下面的CREATE TABLE语句创建了一个使用RANGE_KEY_COLUMN列的区间分区表。
基于8个网页-相关网页
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
When you create a range-partitioned table in DB2 z/OS, the underlying table space is also partitioned and such a partitioned table space can not hold more than one table.
在 DB2 z/OS 中创建一个范围分区的表时,底层的表空间也被分区,并且这样一个分区的表空间无法容纳多个表。
If database partitioning and range partitioning are used together, the rows in a table are first hashed across the database partitions and then range-partitioned within each database partition.
如果数据库分区和范围分区一同使用,那么表内的行首先会跨数据库分区做散列处理,然后再在每个数据库分区中执行范围分区。
应用推荐