If DBCC detects a problem with an index, the name of the index is reported with the type of problem. Use sp_iqrebuildindex to repair a non-FP index. FP indexes cannot be repaired. 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.
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.
