When to reindex

Question

Hi All,

Just a quick question, I am fairly new to the SQL Server world.

Can someone tell me when I should rebuild an index?

Is there some bench mark? A magic number? Should I be looking at certain statistics?

Thanks
Chris

Answer 1

Hi Chris,

I'd start with this white paper:  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Regards,