Indexes[=index-list]
Verifies the integrity of all but disabled indexes in the
database if you specify the Indexes or the Indexes=* qualifier;
verifies the integrity of a specific index, or of multiple
indexes if you provide an index list. If you list multiple
indexes, separate the index names with a comma, and enclose the
index list within parentheses.
Beginning with Oracle Rdb V7.0, Oracle RMU uses a new method to
verify indexes. In prior versions, the verify operation tried
to retrieve the table row to which the index pointed. Beginning
with Oracle Rdb V7.0, the verify operation creates a sorted list
of all dbkeys for a table and a sorted list of all dbkeys in an
index. By comparing these two lists, the verify operation can
detect any cases of an index missing an entry for a data row. In
addition, the verify operation runs faster. This comparison of
dbkeys occurs at the end of the verify operation. If you specify
the log qualifier, you see messages similar to the following to
indicate that the comparison is occurring:
%RMU-I-IDXVERSTR, Index data verification of logical area
60 (DEGREES) started.
%RMU-I-IDXVEREND, Index data verification of logical area
60 finished.
In addition, beginning in Oracle Rdb V7.0, when you verify an
index with the Data qualifier (the default), Oracle RMU also
verifies the logical areas referenced by the indexes. See Example
5 in the Examples help entry under this command.
See the Usage Notes entry in this command for the rules that
determine which qualifiers can be used in combination on the same
RMU Verify command line.
By default, Oracle RMU does not verify indexes.
The Indexes qualifier can be used with indirect file references.
See the Indirect-Command-Files Help entry for more information.