up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
40% accept rate
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
feedback

1 Answer

up vote 1 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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