Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm having a strange problem with a SQL Server Maintenance Plan. It's set up to run a Reorganise Indexes and Rebuild Indexes, the history shows it has succeeded, but the fragmentation is still bad and requires me to manually intervene to fix them.

Has anyone seen this before?

share|improve this question
Which version of SQL? Is it a custom scripted job or was it made using the Maintenance Plan tools? Could you provide the script/tools you used? – Sean Howat Jun 8 '10 at 13:46

You should reorganize or rebuild indexes, not both. Rebuilding an index drops the index and creates a new one, so rebuilding will fix any fragmentation problems. Reference.

share|improve this answer
While this is true, it doesn't really address why the indexes are remaining fragmented after both operations run. – Sean Howat Jun 8 '10 at 16:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.