可以通过执行ALTERTABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区,使用的语法如下所示
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
跨多个分区划分数据库将允许您根据环境中分区数目的因数来增加表的最大大小。
Partitioning a database across multiple partitions lets you increase the maximum size of your table by a factor of the number of partitions in your environment.
DB 2V 9引入了一个表分区特性,它能够增加一个表的可能大小,同时能够显著减少管理大型数据库所需要的维护。
DB2 V9 introduced a table partitioning feature that can increase the potential size of a single table, and significantly reduce the maintenance effort required to manage very large databases.
DPF可以通过增加数据库分区来提高处理能力,因此,随着表的增长,仍然可以保持较高的查询性能。
DPF can maintain consistent query performance as the table grows by providing the capability to add more processing power in the form of additional database partitions.
增加下列结构的有效性:索引或索引分区,表或表分区,索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
增加下列结构的有效性:索引或索引分区,表或表分区,索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
应用推荐