I am trying to reduce the fragmentation of my indexes.
First of all I rebuild all indexes with fragmentation higher than 30%, but the most of my indexes still with high fragmentation or does not even change 1%.
Looking deeply, when I reduce the fill factor on the rebuild statement then reduces the fragmentation too.
Now, what is the best option?
A higher fragmentation with a high fill factor or reduce the fill factor and then gets lower fragmentation?
Thanks for now.