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.
Call SAP Sybase Technical Support for help in determining the best course of action to fix an inconsistent index or table.