Sample Header Ad - 728x90

Sql Server, Is "Reorganize Files Before Releasing Unused Space" better or worse?

12 votes
2 answers
28419 views
I could not find a satisfactory answer. I fully understand that "Shrink" will cause index defragmentation, and that can worsen performance. But, is not this option to reduce defragmentation? So, to activate this option, is it better or worse? Please do not increase my confusion. I ask you to give me a clear and simple answer: it is better, or, it is worse. Then if you want, give me your explanation that I will gladly read and appreciate. enter image description here
Asked by Diego Soto (223 rep)
Aug 19, 2017, 08:01 PM
Last activity: Dec 8, 2022, 03:56 AM