I have used ALTER INDEX REBUILD to remove index fragmentation. In some cases, REBUILD does not seem to remove this fragmentation. What are the reasons why REBUILD does not remove fragmentation?
Is the table particularly small?
Recommendations are generally not to worry about rebuilding indexes unless they're more than a certain size. See, for example, this SQLSkills page - https://www.sqlskills.com/blogs/paul/where-do-the-books-online-index-fragmentation-thresholds-come-from/
Thanks for your response.
16 People are following this question.