Quite contrary to popular belief, index REBUILDs are NOT a problem compared to REORGANIZEs.
Here's just one example. I had a table that had an ever increasing Clustered Key that contained 149 Million rows in 146.3 GB at 12% logical fragmentation. As an experiment, I did backup so I could restore it in that condition as often as I needed to to do some testing on a test box.
After the first restore, I took some measurements of the BEFORE condtions again to verify that nothing had changed. I'd shrunk the log file to just 40GB. I made sure that I was in the FULL recovery model and did a full backup to NUL to make sure. Then, I did a REBUILD. As expected, the log file grew to just bit of 147GB and it took 01:20:45 to complete.
I repeated all of that except I did a REORGANIZE. Although it too about the same time, the log file EXPLODED to 227GB!!! And, it didn't do quite as good a job at defragmenting the data.
I've repeated such test on smaller tables, as well with equally impressive stats. You cannot believe in the myth of REORGANIZE being soe tame, little kitty because it' just not so.
While I was at it, I went through the same setup and then slipped into the BULK LOGGED Recovery Model and did another REBUILD... Folks, this isn't a misprint... It only took 00:12:45 (less than just 13 minutes and the log file only grew to 37GB.
Yeah, I know... all you folks running replication and AG, etc? I DO feel bad for you because you'll break anything that depends on the log file and always having to be in the FULL Recovery Model. I love my clustered servers! 😀
But, even with replication and AG, stop just trusting all the decades old propaganda that REOGANIZE is doing you any favors resource-wise. In fact, since most people don't actually know what it does, you should just stop using it until you do. What does it frequently do? The stuff above AND it also frequently perpetuates fragmentation. In fact, it IS the primary reason that Random GUIDs have such a bad name.
For proof of that, please see the following video presentation.... what it to the very end after the Q'n'A section... you just won't believe it and, yet, I have the code to prove it. 😀