title: DBCC REINDEX after an update on a table
body: <p>I am accessing table with a simple update query, however it gave me this error:
  <br/></p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p><br/>
  Will running DBCC REINDEX do the trick ? </p>