Post reply

Index maintenance Ola script

  • 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

  • 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.

  • 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

  • September 21, 2019 at 4:28 pm

    #3682274

    Thank you.

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

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