After Adaptive Server shuts down, restart it, and use sp_indsuspect to find the user tables that need to be reindexed. The following is the syntax, where tab_name is the optional name of a specific table:
sp_indsuspect [tab_name]
If tab_name is missing, sp_indsuspect creates a list of all tables in the current database that has indexes marked “suspect” when the sort order changes.
In this example, running sp_indsuspect in mydb database yields one suspect index:
sp_indsuspect
Suspect indexes in database mydb Own.Tab.Ind (Obj_ID, Ind_ID) = dbo.holdings.h_name_ix(160048003, 2)
