Post reply

FULLSCAN vs. REBUILD

  • March 26, 2013 at 1:53 pm

    #272497

    Hi All,

    Except that REBUILD eliminates the fragmentation at indexes, is there any other advantage over update of the statistics for the indexes with FULLSCAN option?

    One disadvantage is the more consuming time for REBUILD, but not much more than UPDATE with FULLSCAN.

    If FULLSCAN makes the best update for the stats, then why should I run an everyday REBUILD for all indexes when I know that only few of them get fragmented? Then I will need to do the REBUILD only for them.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • March 26, 2013 at 2:25 pm

    #1600963

    REbuilding an index updates the associated statistics WITH FULLSCAN.

    why should I run an everyday REBUILD for all indexes when I know that only few of them get fragmented?

    You probably shouldn't.

    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

  • March 26, 2013 at 2:58 pm

    #1600970

    Thank you,

    I needed someone to confirm with me.

    IgorMi

    Igor Micev,My blog: www.igormicev.com

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

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