使用分区表的另一个优点是,可以轻松地在表中添加新数据(作为新的数据分区),同时可以轻松地删除并存档老数据。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
TableName:按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
那意味着,无论何时添加或删除分区,都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
应用推荐