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"?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
|
|
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation. |
|||
|
|
