How to use Index Tuning Wizard | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to use Index Tuning Wizard

Dear All,
I am totally new with this index tuning wizard. Wat is the purpose and how to use the index performing tuning? When do we need to use this index tuning wizard?

ITW will give recommentdation to improve performance by introducing indexes and updating statistics. you can use thiw when you feel your queries have low performance.
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

I believe you are using sql 2005 because you posted in 2005 forum… In sql 2005 ITW changed to DTA (Database Tuning Advisor)
For more details read SQL Server 2005 Books Online topic "
Database Engine Tuning Advisor Overview "….
Database Engine Tuning Adviser: How to tune your new SQL Server,289483,sid87_gci1161285,00.html