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:
Logical partition 2 might have the following keys:A B E F T Z
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.M N Q T V X
- CHECK INDEX does not detect keys that are out of sequence between different
logical partitions. For example, the following keys are out of sequence:
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:1 7 5 8 9 10 12
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.