If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?

link|improve this question

80% accept rate
feedback

1 Answer

up vote 4 down vote accepted

You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.

link|improve this answer
Thanks, though that was the case - good to get comformation :) – SuperCoolMoss Sep 15 '09 at 8:12
feedback

Your Answer

 
or
required, but never shown

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