Why index REBUILD does not reduce index fragmentatation?

35 votes

3 answers

43620 views

sql-server index clustered-index fragmentation

                          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? It seems that this happens especially with small indices.
                        

Asked by jrara (5393 rep)

May 24, 2012, 06:03 PM
Last activity: Apr 5, 2023, 06:43 PM

Why index REBUILD does not reduce index fragmentatation?

Related Questions