MicrosoftIf you're doing regular index maintenance based on logical fragmentation, then I have to say again like I have throughout this thread, you are making a mess of things. The supposed "Best Practices" that people have been following for the last 2 decades are basically completely incorrect and MS recently changed their documentation on the subject to reflect that. And, using REORGANIZE on most indexes is actually causing you problems because you don't actually know how REORGANIZE actually works. I know this because you're still using it, right?
Here's the Documentaiton that MS has been revising since the 20th of April, 2021. It's still not totally correct because it still doesn't warn of the serious problems with REORGANIZE but it's a start... notice where it says that index maintenance may not be helping you.
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16#index-maintenance-strategy
