sql server - Index defragmentation -

Please tell me to make a process for defragging the index on a daily basis in MS SQL Server 2000.

Appreciate your answer

Joseph

< One of the simplest ways:

  EXEC sp_MSForEachTable 'DBCC DBREINDEX (' '', '' ', 90 ) ''  

There are many other options where people