Post reply

Index rebuild

  • August 13, 2013 at 7:51 am

    #276876

    Hi Team,

    After Rebuilding index, Total fragmentation is still showing 75.

    please suggest what to do.

  • August 13, 2013 at 8:09 am

    #1640953

    How big is the table i.e. number of rows - if it only a small table then this could well be the case. Also what value were you expecting based on your fill factor?

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • August 13, 2013 at 8:24 am

    #1640960

    And are you sure that this isn't a heap?

  • August 13, 2013 at 8:29 am

    #1640964

    Let me guess, the index is 4 pages in size (at the leaf level)?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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