可以通过执行 ALTER TABLE 语句并指定 ADD PARTITION 选项来向一个分区表增加一个新的空分区,使用的语法如下所示
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 2 V 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.
应用推荐