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
a heap is a table without an index - it's unordered. You can't reorder something that's not ordered by an index.
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:
Sue
September 21, 2019 at 4:28 pm
Thank you.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy