Index Problems that DBCC Cannot Repair

Use these suggestions to repair inconsistent indexes.

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. Analyze index errors 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.

Sybase recommends calling Sybase Technical Support for help in determining the best course of action to fix an inconsistent index or table.

Related concepts
Analysis of Index Errors