best way of fixing the glitch

• dschlobohm

  SSCommitted

  Points: 1521

  More actions

  April 29, 2016 at 9:40 am

  #318686

  i found a glitch in a sql db index frag job that was suppose to tell everyone that the indexes needed to be re-indexed

  unfortunately if was only doing the master database and was copied to over 200 servers over a 1 year ago

  So i looking for what method would be best

  drop recreate or rebuild online

  one server I was looking at had over 3 billion indexes rows

  or maybe there is a better way

• kreuzer

  Ten Centuries

  Points: 1266

  More actions

  May 1, 2016 at 11:52 pm

  #1875831

  Hi,

  I think it "depends" on you database. Have you checked the maintenance scripts from Ola Hallengren?

  There is a stored procedure to rebuild/reorg you index, depending on the fragmentation-level and on the size of the index.

  https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

  Kind regards,

  Andreas