How to perform periodic database re indexing by using SSMS ?

The performance of your indexes, and therefore your database queries, will degrade as you indexes become fragmented. The Rebuild Index task does a very good job of rebuilding indexes to remove logical fragmentation and empty space, and updating statistics. As such, it is very important that you schedule this task to run regularly.
 

• Nightly, if required. If your indexes fragment rapidly, and you have a nightly maintenance window that allows you to run the Rebuild Index task, rebuilding every night can’t do any harm, and can very well boost the performance of your server.
• Weekly, at minimum. If you can’t perform this task nightly, then, at a minimum, it should be run once a week, during a maintenance window.

 

• Open up SQL Server Management Studio
• Expand out Management
• Right Click on Maintenance Plans
• Choose Maintenance Plan Wizard 

Name your plan something you can remember what it does "Rebuild Indexes For Footprints" for example.

• Click Next
• Check "Rebuild Index"  and "Update Statistics"

• Click Next
• Rebuild should be at the top
• Click Next
• Choose under Databases: Footprints
• Click Next
• Choose under Databases: Footprints
• Click Next
• Note or Change the location of the report of this task
• Click Next
• Click Finish
• Final screen upon successful creation 

• Our final step is to define an appropriate schedule on which to run our Rebuild Index job.

 

•