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

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.

That is the equivalent of shrinking. To prove it, check the box and click the Script button at the top to see the shrink commands that it produces.

Generally speaking, that’s a great learning tool too - whenever you want to learn what something in the UI does, try that script button.

StackExchange Database Administrators Q#183905, answer score: 11