DBCC REINDEX after an update on a table

Question

I am accessing table with a simple update query, however it gave me this error:

Error : Index id 3 on table id 128716480 cannot be used in the optimization of a query as it is >SUSPECT. Please have the SA run DBCC REINDEX on the specified table.

Will running DBCC REINDEX do the trick ?

score 2 · Accepted Answer · answered May 23 '13 at 13:55

2

Yes. Running that will rebuild the tables indexes. The only time that may not work is if you are dealing with system tables/system indexes.

answered May 23 '13 at 13:55

Mike Gardner

6,611
5
24
34

DBCC REINDEX after an update on a table

1 Answers1