I have an index maintenance job that runs frequently, what I find is that despite the fact that the script runs, fragmentation is still quite high on the tables. I am using the standard approach of having a rebuild if fragmentation is over 20 and if
its between 5 and 20 then it reorganises the page.
Is this usual for such a behavior ?
View Complete Post