On this issue of index, what are the implications of having duplicate indexes. I have some on my inherited server and I want to gwet rid of the duplicates.

However, I want to know what the implications will be.

Thanks.