Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.