Index rebuild/reorganize fragmentation percentage mean the internal (inside the page) or external (amongst pages)fragmentation?



  • Fragmentation of 5% - reorganize

    Fragmentation of 30% - rebuild

    Index rebuild/reorganize fragmentation percentage mean the internal (inside the page) or external (amongst pages)fragmentation?



  • Those numbers refer to external fragmentation.

    Note that with modern disk-subsystems you likely won't gain anything, or very little, by defragmenting your indexes. I have blogged about it, including some measurements, here: https://sqlblog.karaszi.com/index-fragmentation-revisited/




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2