Index maintenance Ola script

  • vsamantha35

    SSChampion

    Points: 11044

    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: 62457

    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: 90260

    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: 11044

    Thank you.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply