Performance problems issued by duplicate indexes
In this post I would like to show you with a hands-on example why it
is a bad idea to have duplicate indexes on SQL Server tables.
Some people believe that having duplicate indexes will improve the performance. There will be no performance gain for SELECT statements and there will be a performance degradation for INSERT,UPDATE,DELETE statements.
Have a look in this post if you want to learn about the possible dangers of over indexing your tables.
We will need a database to work with. I will use AdventureWorks2008R2. You can download it here . (read more)