469,275 Members | 1,515 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

Index Tuning Wiz recommends negative performance improvements?

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

Jul 20 '05 #1
0 1164

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.