Neeraj Dwivedi (5/10/2013)
Also make sure that your analysis have not excluded Foreign keys. Because lot many scripts available online do not consider FK while doing unused Index analysis.I do agree with Gail that, for what period of time you have done this analysis.
And again this is not a small change. It is really-2 a big change.
Neeraj, As I know my system, I can say removing these indexes will be no big change. For a matter a fact, I would agree that removing or creating an index is always big change from performance's perspective.