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"?
|
feedback
|
|
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation. | |||
|
feedback
|