If a user never runs
REORGANIZE on their database, does SQL Server still somehow defragment the indexes?
MSDN suggests that if an index is over 30% fragmented, it is recommended to run
REBUILD instead of
REORGANIZE. Would running
REORGANIZE multiple times do the same things as
I wonder about this because I have a client that has a highly fragmented index. They run
REORGANIZE against that index every weekend, and over time it seems like their index becomes defragmented.
Does this make sense?