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.
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.
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.
