Hi,
Does anyone have Rebuild Index Script for entire database?
Thanks in advance...j
Printable View
Hi,
Does anyone have Rebuild Index Script for entire database?
Thanks in advance...j
You do not mention on which RDBMS you are working. But on SQL Server there are several possibilities to achieve that.
1) Create a Maintenance plan which rebuilds the indexes
2) Look up usage ob DBCC in BOL
3) Script all tables including Indexes and derive the bits and pieces to rebuild the indexes from the script