After Adaptive Server shuts down, restart it, and use sp_indsuspect to find the user tables that need to be reindexed.
sp_indsuspect [tab_name]
where tab_name is the name of the table you are investigating. 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.
This example shows that 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)
