I am wondering if I should take into account information from
when deciding on defragmenting/not defragmenting an index.
How is it possible that I see low
avg_fragmentation_in_percent value and also low value for
Based on Brent Ozar article I could think that I should rebuild an index as there is a lot of free space on pages so it is a waste of disk and RAM space.
But scripts as Ola Hallengren's, for example, analyze only
avg_fragmentation_in_percent, don't they?