Global Range Partitioned Indexes

最新推荐文章于 2024-09-27 14:48:29 发布

转载最新推荐文章于 2024-09-27 14:48:29 发布 · 198 阅读

本文详细介绍了全局范围分区索引的特点与使用方法。这种索引类型提供了灵活的分区方式，独立于表的分区方法，并适用于在线事务处理(OLTP)环境。它能够高效地访问任意单个记录，并确保底层表中的所有行都能在索引中得到表示。

Global range partitioned indexes are flexible in that the degree of partitioning and the
partitioning key are independent from the table's partitioning method. They are
commonly used for OLTP environments and offer efficient access to any individual
record.

The highest partition of a global index must have a partition bound, all of whose
values are MAXVALUE. This ensures that all rows in the underlying table can be
represented in the index. Global prefixed indexes can be unique or nonunique.

You cannot add a partition to a global index because the highest partition always has a
partition bound of MAXVALUE. If you wish to add a new highest partition, use the
ALTER INDEX SPLIT PARTITION statement. If a global index partition is empty, you
can explicitly drop it by issuing the ALTER INDEX DROP PARTITION statement. If a
global index partition contains data, dropping the partition causes the next highest
partition to be marked unusable. You cannot drop the highest partition in a global
index.

[@more@]

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

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