• HEAP's cannot be rebuilt - they will always show fragmentation.

    As for the other indexes, how many pages in the index? What are the data types for the indexes? What is the fill factor defined as? And finally, what kind of activity is performed on that table?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs