Index maintenance Ola script

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  September 20, 2019 at 7:02 pm

  Go to Answer

  #3682071

  Hi All,

  Does Ola Hallengren index script takes care of de-fragmenting HEAP tables as well? or just clustered and non-clustered indexes?

  Thanks,

  Sam

• pietlinden

  SSC Guru

  Points: 63584

  More actions

  September 20, 2019 at 7:03 pm

  #3682076

  a heap is a table without an index - it's unordered. You can't reorder something that's not ordered by an index.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 20, 2019 at 7:57 pm

  Answer

  #3682080

  vsamantha35 wrote:

  Hi All,

  Does Ola Hallengren index script takes care of de-fragmenting HEAP tables as well? or just clustered and non-clustered indexes?

  Thanks,

  Sam

  No, just indexes. It's in the FAQ - under Why are some of my indexes still fragmented:

  Frequently Asked Questions

  Sue

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  September 21, 2019 at 4:28 pm

  #3682274

  Thank you.