Post reply

Reorganize Indexes in sql 2008

  • September 14, 2012 at 12:56 am

    #281538

    Hi,

    I have done reorganizing of 76 indexes.

    But after that some of the indexes have no effect.

    Can anyone explain why SQL is not able to do that?

  • September 14, 2012 at 2:11 am

    #1537674

    Do what? What do you mean by "have no effect"?

  • September 14, 2012 at 2:47 am

    #1537685

    Let me guess....

    You've seen no change in fragmentation. These tables are all very small, maybe a few hundred to a few thousand rows.

    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

  • September 24, 2012 at 2:57 am

    #1541302

    Yes Gail, fragmentation value was not changed.

    I checked the page count for those tables and it was below 100.

    Thanks ALL.

  • September 24, 2012 at 3:00 am

    #1541303

    Table is to small for it to be reorganized, typically anything less than 1000 pages should be excluded from rebuilds/reorganizations.

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

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