Home » Databases » Sybase » ASE » Finding suspect indexes in Sybase ASE

Finding suspect indexes in Sybase ASE

Problem: ASE does not use an index on a table because it is marked suspect

Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.
Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.
Index id 2 cannot be used to access table id 864003078 as it is SUSPECT. Please have the SA run the DBCC REINDEX command on the specified table.

Solution:  Use sp_indsuspect to identify the suspect indexes in a database and run dbcc reindex(<tablename>) tables.

dbcc reindex can only be executed on a single table at a time in a database so if time is short, you may be better off dropping and creating the indexes in parallel.

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Facebook login by WP-FB-AutoConnect