As part of a SQL Database maintenance plan it is possible to re-index the database tables.
As Microsoft SQL Server maintains indexes to reflect updates to their underlying tables, the indexes can become fragmented. Depending on workload characteristics of your SQL database, this fragmentation can adversely affect workload performance.
A SQL database can benefit from its indexes being ‘rebuilt’ occasionally; you should consult your SQL server administrator to determine if your database should be re-indexed.
There are five scripts which can be used to schedule different groups of table reindexing within a SQL scheduled job. These can be downloaded from here.