Tuesday, September 7, 2010

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.

No comments:

Post a Comment