下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
将一个已填充的表添加到一个分区表。
散列分区是用于确定每一行在分区表中的位置的方法。
Hash partitioning is the method by which the placement of each row in the partitioned table is determined. The method works as follows.
不支持哈希分区表。
支持临时表、常规表以及范围和列表类型的分区表。
Supports temporary, regular and partitioned tables of different types of range and list.
TableName：通过名称标识将添加新分区的分区表。
TableName: Identifies the partitioned table, by name, that a new partition is to be added to.
TableName：按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
正如可以向分区表添加或附加新分区一样，也可以删除现有分区。
Just as you can add or attach new partitions to a partitioned table, you can also remove existing partitions.
如下的语法示例展示了创建一个哈希分区表所需步骤。
The following syntax examples demonstrate the steps necessary to create a hash-partitioned table.
MBR是磁盘上的第一个扇区，因而分区表在其中所占空间不大。
The MBR is the first sector on the disk, so the partition table is not a very large part of it.
限定分区扫描允许DB 2将数据扫描限制在一个分区表空间中。
Limited partition scan is a method that allows DB2 to limit the scan of data in a partitioned table space.
它是通过在分区表中查找一个活动分区来实现这种功能的。
It does this by looking through the partition table for an active partition.
例如，NDB存储引擎支持分区表，内存引擎支持内存表。
For example, NDB storage engine supports partitioned tables and memory engine supports in-memory tables.
DB 210现在支持自动重新组织分区表空间的不相连分区范围。
DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.
IPL查询分区表，从而能够加载位于不同介质上任意位置的数据。
The IPL interrogates the partition table and subsequently is able to load data wherever it may exist on the various media.
只有满足以下条件，现有基表才能被添加(附加)到分区表。
Before an existing base table can be added (attached) to a partitioned table, the following conditions must be met.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
所以，在提交任何修改之前您都可尝试不同的选项并预览分区表。
So, you can try different options and preview the partition table before committing to any changes. This sequence of commands creates a single partition
Q：如何计算已分区表（或者任何相关的表）的表大小和索引大小？
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
上面的分区表使用了MTD_BLOCK接口对闪存设备进行分区。
The above partition table USES the MTD_BLOCK interface to partition the flash device. The device nodes for these partitions are.
支持用户表、临时表、常规表以及范围、哈希和多维簇类型的分区表。
Supports user, temporary, regular and partitioned tables of different types range, hash and multidimensional clusters.
DB 2Viper中的一个分区表最大可以达到512exabyte ！
A partitioned table in DB2 9 can be up to 512 exabytes in size!
执行这样一个语句时，一个新表将创建，并在逻辑上构成分区表的一部分。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
理想情况下，一个哈希分区表内的每个数据库分区都应具有相同数量的记录。
Ideally, each database partition in a hash-partitioned table should hold the same number of records.
如果sql表是一个分区表，每个分区(成员)都可以有一个单独的媒介首选项。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
尤其是，对于范围分区表，仍然可以使用以前支持的创建和修改表的sql语句。
In particular, the previously supported SQL statements for creating and altering tables for range partitioning as well as attaching and detaching partitions still apply.
当找到一个活动分区时，它会扫描分区表中的其他分区，以确保它们都不是活动的。
When it finds an active partition, it scans the remaining partitions in the table to ensure that they're all inactive.
在创建分区之后，应该会在分区表中看到一个(或多个)LinuxLVM分区。
After you've created a partition, you should see one (or more) Linux LVM partitions in your partition table.
在创建分区之后，应该会在分区表中看到一个(或多个)LinuxLVM分区。
After you've created a partition, you should see one (or more) Linux LVM partitions in your partition table.
应用推荐