Index Tuning

What is “Index Tuning Wizard” in sqlserver 2005?
Index Tuning Wizard is a software application that identifies tables which have inefficient indexes. It makes recommendations on how indexes should be built on a database to optimize performance. The recommendations are based on T-SQL commands that the wizard analyzes.

List out what Index Tuning Wizard can do in Sqlserver 2005

1. It identifies tables in need of an index change
2. Implements recommendations
3. Determines how a proposed change might affect performance
4. Has the capability to make indexes change immediately and schedule them
5. Helps to tune indexes.