N Shashidhar Reddy

N Shashidhar Reddy

  • 1.8k
  • 38
  • 852

Why index REBUILD does not reduce index fragmentation?

Aug 8 2019 12:05 AM
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)