Use segmented or partitioned table Spaces.
使用分段的或分区的表空间。
Attaching a populated table to a partitioned table.
将一个已填充的表添加到一个分区表。
A partitioned table in DB2 9 can be up to 512 exabytes in size!
DB 2Viper中的一个分区表最大可以达到512exabyte ！
In general, the larger the table, the more reason to create it as a partitioned table.
通常，表越大，就越有理由将其创建为分区的表。
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的分区表和索引策略》。
I also described two ways to use the partition BY clause of the create table statement to create partitioned tables.
我还描述了使用CREATETABLE的PARTITIONBY子句来创建分区表的两种方法。
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.
您正在设计一个将被哈希分区的新表，或者您已经有了一个哈希分区的表，并且此表有可能会存在数据倾斜问题。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在DB 2UDBV 7中创建分区的表空间时，DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
Once the table Q1_2010_SALES becomes available, you can either drop it (to delete the data) or attach it to another partitioned table (for example, to archive it).
一旦表q 1_2010_sales变得可用，可以删除它(以删除数据)，或者将其添加到另一个分区表(例如，以对其存档)。
Managing a range-partitioned table that includes one or more XML columns isn't much different from managing a range-partitioned table with only relational columns.
与管理只包含关系列的范围分区表相比，管理包含一个或多个XML 列的范围分区表的差异并不大。
When lookup tables are used in joins with other large partitioned table spaces, you can maximize the parallelism in the join by partitioning the lookup tables as well.
当将查找（lookup）表与其他较大的分区的表相连接时，通过将查找表也进行分区，可以最大化并行度。
A new, empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified; the syntax used looks like this
可以通过执行ALTERTABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区，使用的语法如下所示
应用推荐