Post reply

Update Stats After Alter Index Statement

  • October 10, 2008 at 11:00 am

    #124270

    Hi All

    Do i have to update database status using SP_Updatestats after using alter index statement for table defragmentation

    I am using SQL 2005 🙂

    I am Pity much sure that alter index all updates stats, Please clear my doubts on this

    Cheers

    🙂

  • October 10, 2008 at 11:48 am

    #883577

    CrazyMan (10/10/2008)

    Hi All

    Do i have to update database status using SP_Updatestats after using alter index statement for table defragmentation

    I am using SQL 2005 🙂

    I am Pity much sure that alter index all updates stats, Please clear my doubts on this

    Cheers

    🙂

    If you are "reorganizing" you should update the stats, which by the way can be done at the "INDEX" level.

    If you are "rebuilding" you don't need to update the stats. It is done in the process.


    * Noel

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

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