Hi,
I've run the (SQL2K) Index Tuning Wizard against our 50GB database and
it has recommended changes that will produce a "-3506%" improvement iin
performance.
The recommendations include a lot of indexes to be dropped and a few
new ones to be created, in the Analysis - Query Cost Report screen all
of the indexes shown have a zero or negative percent improvement (e.g.
-96133%).
Why is it recommending these changes? Are these actual improvements or
is something wrong?
thanks,
Nathan