The following are the uses of Index Tuning Wizard:
1>For a given workload,the best possible combination of indexes for a database is recommended.
2>The effects of the proposed recommendation about the indexes, distribution of queries among tables,and the query performance in the workload can be analyzed.
3>For a small set of problem queries,the way to tune the database will be recommended.
4>It will specify the advanced options such as the disk space constraints that can be customized.
The recommendation provided by the wizard can either be implemented immediately ,or saved and executed manually by the user at later time,or can be implemented later by creating a SQL Server job to execute a SQL script.
|
| Author: Mayur 20 Jun 2008 | Member Level: Silver Points : 1 |
Hi Dude,
Thanks for the info.
Looking forward can you add some more info about index tuning wizard?
|