CHECK-LIMITKEYS—Check the Index Keys

The CHECK-LIMITKEYS keyword checks whether each key that is written to an index belongs in the partition for which it is written.
cafrdb2
The CHECK-LIMITKEYS keyword checks whether each index key belongs in the partition for which it is written. Use this keyword when you are migrating data, to verify that the source and target object have matching DDL definitions.
CHECK-LIMITKEYS is
not
valid with RECOVER TABLESPACE and RECOVER INDEX.
This keyword has the following format:
CHECK-LIMITKEYS {
NO
|YES}
  • NO
    Does not check each key. This value is the default.
  • YES
    Checks each key. Specifying YES can degrade performance.