您可以使用“p”来显示当前的分区表。
可以随时按下“p ”预览新的分区表。
下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
示例:创建已分区表和已分区索引。
Example: Create a partitioned table and a partitioned index.
非分区表空间的单个数据集。
将一个已填充的表添加到一个分区表。
分区表空间:分区表空间只能包含一个表。
Partitioned: A partitioned table space may contain only a single table.
不支持哈希分区表。
分区表位于磁盘主引导记录(MBR)之中。
The partition table is located in the master boot record (MBR) of a disk.
Q:我如何能辨别已分区表上的索引是否被分区?
Q: How can I tell if an index on a partitioned table is partitioned?
支持临时表、常规表以及范围和列表类型的分区表。
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.
执行这样一个语句时,一个新表将创建,并在逻辑上构成分区表的一部分。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
执行这样一个语句时,一个新表将创建,并在逻辑上构成分区表的一部分。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
应用推荐