If DBCC detects a problem with an index, the name of the index is reported with the type of problem. Some problems can be repaired, while others can only be resolved by dropping an index, column, or table. If the DBCC output contains the errors “Inconsistent Index” or “Missing Index RIDs,” DBCC may be able to fix the index. See the section “Analyzing index errors” for the procedure to follow for indexes reported as “Inconsistent Index,” when sp_iqcheckdb is run in default or check mode.
If an index is reported as “Inconsistent Index” after you run sp_iqcheckdb in repair mode to repair the index, then this index cannot be fixed. Depending on the type of problem, use DROP INDEX, ALTER TABLE DROP COLUMN, DROP TABLE, or the FORCE_DROP option to resolve the problem. See the section “Dropping inconsistent indexes, tables, or columns”.
Sybase recommends calling Sybase Technical Support for help in determining the best course of action to fix an inconsistent index or table.
