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"?
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
5 years ago