SQL Server Performance

help plz

Discussion in 'Performance Tuning for DBAs' started by lara99, Nov 20, 2007.

  1. lara99 New Member

    Hi Gurus,
    1.My index tuning wizard gives the analysis result in -ve does it mean if I follow
    to delete the indexes will the performance will be lost.
    Thankyou.
  2. Luis Martin Moderator

    No way.
    You only have to add the indexes suggested by ITW.
    If you delete all the indexes ITW suggested, you will loose all other optimization.
    You run ITW for one query, for that query ITW suggest to create a new indexes and delete all the others. But "the others" could be useful for others queries.
    So, you have to uncheck that option.
  3. ranjitjain New Member

    Report generated by ITW is just a guideline or suggestion given by it, so it's not that you should always adopt all the suggestions. Test them, check the results, plans and then finalise those creations of indexes.

Share This Page