Single logical partitions

You can run CHECK INDEX on a single logical partition of a secondary index. However, what CHECK INDEX can detect is limited.

  • CHECK INDEX does not detect duplicate unique keys in different logical partitions. For example, logical partition 1 might have the following keys:
    A  B  E  F  T  Z
    Logical partition 2 might have the following keys:
    M  N  Q  T  V  X
    In this example, the keys are unique within each logical partition, but both logical partitions contain the key, T; so for the index as a whole, the keys are not unique. CHECK INDEX does not detect the duplicates.
  • CHECK INDEX does not detect keys that are out of sequence between different logical partitions. For example, the following keys are out of sequence:
    1  7  5  8  9  10  12
    If keys 1, 5, 9, and 12 belong to logical partition 1 and keys 7, 8, and 10 belong to logical partition 2, the keys within each partition are in sequence, but the keys for the index, as a whole, are out of sequence, as shown in the following example:
    LP 1   1     5     9      12 LP 2   7     8     10

    When checking a single logical partition, CHECK INDEX does not detect this out-of-sequence condition.