2
Answers

Why index REBUILD does not reduce index fragmentation?

Hi,
 
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?
Answers (2)