Use segmented or partitioned table Spaces.
使用分段的或分区的表空间。
Attaching a populated table to a partitioned table.
将一个已填充的表添加到一个分区表。
Individual dataset of a non-partitioned table space.
非分区表空间的单个数据集。
Example: Create a partitioned table and a partitioned index.
示例：创建已分区表和已分区索引。
A partitioned table in DB2 9 can be up to 512 exabytes in size!
DB 2Viper中的一个分区表最大可以达到512exabyte ！
Q: How can I tell if an index on a partitioned table is partitioned?
Q：我如何能辨别已分区表上的索引是否被分区？
Partitioned: A partitioned table space may contain only a single table.
分区表空间：分区表空间只能包含一个表。
Complete table space (Non-partitioned or all partitions of a partitioned table).
完整的表空间(非分区的或分区表的所有分区)。
In general, the larger the table, the more reason to create it as a partitioned table.
通常，表越大，就越有理由将其创建为分区的表。
Howerver, gathering global statistics for the partitioned table may still be necessary.
有时候表的全局的统计信息也是很重要的。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
TableName：按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a new partition is to be added to.
TableName：通过名称标识将添加新分区的分区表。
DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.
DB 210现在支持自动重新组织分区表空间的不相连分区范围。
The following syntax examples demonstrate the steps necessary to create a hash-partitioned table.
如下的语法示例展示了创建一个哈希分区表所需步骤。
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
Q：如何计算已分区表（或者任何相关的表）的表大小和索引大小？
Ideally, each database partition in a hash-partitioned table should hold the same number of records.
理想情况下，一个哈希分区表内的每个数据库分区都应具有相同数量的记录。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
如果sql表是一个分区表，每个分区(成员)都可以有一个单独的媒介首选项。
Limited partition scan is a method that allows DB2 to limit the scan of data in a partitioned table space.
限定分区扫描允许DB 2将数据扫描限制在一个分区表空间中。
Just as you can add or attach new partitions to a partitioned table, you can also remove existing partitions.
正如可以向分区表添加或附加新分区一样，也可以删除现有分区。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
执行这样一个语句时，一个新表将创建，并在逻辑上构成分区表的一部分。
Before an existing base table can be added (attached) to a partitioned table, the following conditions must be met.
只有满足以下条件，现有基表才能被添加(附加)到分区表。
Those interested in this can read the white paper Partitioned Table and Index Strategies Using SQL Server 2008.
对此感兴趣的读者可以阅读白皮书《使用SQL Server 2008的分区表和索引策略》。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Hash partitioning is the method by which the placement of each row in the partitioned table is determined. The method works as follows.
散列分区是用于确定每一行在分区表中的位置的方法。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
源表必须是非分区表，或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
Starting in DB2 Version 9.7 Fix Pack 1, you can create an index over XML data on a partitioned table as either partitioned or nonpartitioned.
从DB2Version 9.7FixPack1 开始，在分区的表上创建的XML数据索引可以是分区的，也可以是不分区的。
Reorganizing a partition will put the entire table offline if the partitioned table has any global indexes besides XML column path indexes.
如果已分区表包含任何xml列路径索引以外的其他全局索引，重组一个分区会导致整个表脱机。
Thus, if you wanted to add an empty partition to a partitioned table named SALES, you could do so by executing an ALTER table statement similar to this.
这样，如果您想添加一个分区表名为SALES的空分区，可以执行一个与下面类似的ALTERtable语句。
You are either designing a new table that will be hash-partitioned, or you have an existing hash-partitioned table that might have a data skew problem.
您正在设计一个将被哈希分区的新表，或者您已经有了一个哈希分区的表，并且此表有可能会存在数据倾斜问题。
应用推荐