Post reply

non cluster index even after rebuild is 71 % fragemented

  • February 5, 2012 at 3:27 pm

    #251027

    I have a non cluster index (primary key of a table that is referenced by several foreign keys all over the database) even after rebuild it is 71% fragmented

    Does this have to do with the foreign keys referencing it

    how to reduce its fragmentation

  • February 5, 2012 at 5:56 pm

    #1442871

    No, it has nothing to do with foreign keys.

    Let me guess, the table is under 50 pages?

    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

  • February 6, 2012 at 6:44 am

    #1443083

    Microsoft says:

    Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages.


    Franco

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

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