Re building Indexes of sql 2005 database - TechRepublic
Question
October 16, 2012 at 04:44 AM
ianwheeler

Re building Indexes of sql 2005 database

by ianwheeler . Updated 13 years, 8 months ago

Hi
We have a small sql 2005 database (9Gb), but a couple of tables are under alot of action (for us).

I am interested in re-indexing but would like some real life comments of how to plan, test and impliment a rebuild indexes not just on tables but our main reporting views and of course what are the main pitfalls.

I have a couple of test databases where I was planning to to try this out first and see if the action did improve response time

Do you have a couple of good links to read up on this first

Ian

This discussion is locked

All Comments