Index Error Repair

Use the sp_iqrebuildindex procedure to repair an index, then run sp_iqcheckdb in verify mode to check for index inconsistencies.

If an index is still inconsistent, drop and recreate the index, and then rebuild the index.

Note: The sp_iqrebuildindex procedure cannot repair FP indexes. SAP Sybase IQ has no functionality to repair FP indexes.
Parent topic: Database Repair