Step 1: Launch SQL Server Management Studio and In the Object Explorer expand the Management folder.
Step 2: Right click on the Maintenance Plans folder and select New Maintenance Plan.
Step 3: Give the meaning full name to maintenance plan.
Step 4: From the Toolbox drag and drop a Check Database Integrity Task, Rebuild Index Task, Update Statistics Task and place them vertically in the same order.
Step 5: Connect the tasks together by dragging the arrow from one box to the other so they are connected as: Check Database Integrity Task – Rebuild Index Task – Update Statistics Task.
Step 6 Right click on the each tasks and select the databases in maintenance plan.
Step 7 Schedule a maintenance plan to run in off business hours.