The sp_iqcheckdb stored procedure can only show index inconsistencies. Use the sp_rebuildindex procedure to repair an index, and then run sp_iqcheckdb in verify mode to check for inconsistencies. If an index is still inconsistent, drop and recreate the index as described in the section “Dropping inconsistent indexes, tables, or columns”, and then rebuild the index. For examples of index repair, see “sp_iqrebuildindex procedure” in Chapter 7, “System Procedures,”in Reference: Building Blocks, Tables, and Procedures.
The sp_iqrebuildindex procedure
cannot repair FP indexes. Sybase IQ has no functionality to repair
FP indexes.
