Which task should you include in the maintenance plan?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod includes adatabase named Research.
The Research database contains many indexes. Users report that the Research database is experiencing performance issues.
Upon investigation, you discoverthat the indexes for the Research database are showing an average fragmentation of 20 percent.
You decide tocreate a maintenance plan that will run on a weekly basis to resolve this issue.
Which task should you include in the maintenance plan?