Too many indexes for this table?

[joacker]

Hello,

i have a table with 25 fields that holds 8 million rows. For this table i use 13 indexes. Why? I set an index for every field that's used often for join or where operations.

But i read that using too many indexes is not recommendet. So i want to ask you experts: Can i use the indexes i have at the moment? Should i reduce them? What's your opinion here?

Thx for your help

 

[mrdenny]

If you aren't using the indexes then remove them. If you are using them then they are needed and should not be removed.

You should also check your execution plans and make sure that you are using the indexes correctly. A lot of the time a single column index isn't the best solution.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog