Maintenance of Global Partitioned Indexes

最新推荐文章于 2024-07-04 13:48:38 发布

转载最新推荐文章于 2024-07-04 13:48:38 发布 · 133 阅读

本文介绍了在堆组织表上进行特定分区操作时，默认情况下会标记所有全局索引为不可用的情况，并提供了通过附加UPDATE INDEXES子句来维持这些索引的方法。

By default, the following operations on partitions on a heap-organized table mark all
global indexes as unusable:
ADD (HASH)
COALESCE (HASH)
DROP
EXCHANGE
MERGE
MOVE
SPLIT
TRUNCATE

These indexes can be maintained by appending the clause UPDATE INDEXES to the
SQL statements for the operation. The two advantages to maintaining global indexes:
■ The index remains available and online throughout the operation. Hence no other
applications are affected by this operation.
■ The index doesn't have to be rebuilt after the operation.
Example: ALTER TABLE DROP PARTITION P1 UPDATE INDEXES;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1002167/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1002167/