Showing posts with label What is “Index Tuning Wizard” in sqlserver 2005. Show all posts
Showing posts with label What is “Index Tuning Wizard” in sqlserver 2005. Show all posts

Tuesday, September 7, 2010

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.
Come up with comments if any one wants to add more for this article... :)