DB2 9.7 table partitioning enhancements.
DB 2 9.7表分区增强。
Usually the table partitioning key will be a time-based column.
通常表分区键是基于时间的列。
TP will only benefit those queries that include the table partitioning key column.
TP只对那些包括表分区键列的查询有利。
The columns used in this definition are referred to as the table partitioning key columns.
该定义中使用的列被称为表分区键列。
You can store data in different partitions in the same table of a database using table partitioning.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
MTK now provides support for translating Oracle range partitioning (also known as table partitioning).
MTK现在提供对转换Oracle范围分区(也称表分区)的支持。
This article introduced the following DB2 table design features: table partitioning, MDC, DPF, and MQT.
本文介绍了以下DB2表设计特性：表分区、MDC、DPF和 MQT。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
对于TP，设计决定包括选择用作表分区键的列和分区的数量。
The group of columns specified make up the partitioning key for the table —see sidebar, "Choosing a table partitioning key."
指定的列组成表的分区键 —参见边栏 “选择表分区键”。
However, since XML columns cannot be part of the table partitioning key, any unique XML values index will have to be created as a global index.
然而，由于xml列不属于表分区键的一部分，任何唯一xml值索引必须创建为全局索引。
In my last column, I explained how you can use table partitioning to organize data across multiple storage objects based on values in one or more columns.
在我的上一期专栏中，我阐述了如何使用表分区，基于一列或多列中的值，跨多个存储对象组织数据。
A typical design for a database with monthly roll-out based on sale_date, would be to use sale_date as the table partitioning key and create a separate partition for each month.
对于需要每月根据sale_date转出数据的数据库，一种典型的设计是使用sale_date作为表分区键，并为每个月创建一个单独的分区。
Table partitioning offers the following.
表分区特性提供以下收益。
More exhaustive explanation can be obtained from developerWorks article, Table partitioning in DB2 9.
更详尽的解释可以参阅 developerWorks文章Table partitioning inDB2 9。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
RANGE/TABLE PARTITIONING（DB29提供） ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
应用推荐