I am using SQL server, and the person creating our database added lots of indexes on our biggest table. These indexes only include one field each.
To me it seems that these indexes are mostly useless, and that this was a bad idea.
My concern is removing some or all of these indexes and affecting performance on our live system. There is no way to test this on our test system because our test system doesn't have the same load or amount of data.
- Is there a way to work out which indexes are never used?
- Is there some kind of analysis that will show which indexes are used for what queries over a period of time for instance?