Update Stats with Reindex

  • Sugesh Kumar

    One Orange Chip

    Points: 27311

    Comments posted to this topic are about the item Update Stats with Reindex

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Vivien Xing

    SSChampion

    Points: 12297

    I think answer "Yes" is also right. A simple/straightforward answer.

    "Yes, with full table scan details" is just an answer with more details.

    Reindex, of course, a full table scan.

  • rajankjohn

    SSCertifiable

    Points: 5001

    How come "Yes" a wrong answer?

  • Philip Barry

    SSCrazy

    Points: 2562

    Vivien Xing (8/13/2008)


    I think answer "Yes" is also right. A simple/straightforward answer.

    "Yes, with full table scan details" is just an answer with more details.

    Reindex, of course, a full table scan.

    I agree, 'Yes' is still a valid answer, with a little less qualification.

    Regards,

    Phil

  • dunnjoe

    SSCrazy

    Points: 2180

    I liked the question, but think the answer could have been just yes. I didn't know that the table scans stats were included "free" in the rebuild. A question I have, if you do update stats with a sample scan, after a rebuild, you lose the table scan stats. If you do generic update stats after rebuild do you also lose the table scan stats? If so, then doing rebuild would always be preferred to update stats?

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715079

    I've updated the question to show partial scan with the plain yes answer and awarded back points.

  • Cliff Jones

    SSChampion

    Points: 10517

    I liked the point of the question and I hope that is not missed. I have seen occassions where the DBA performed a REINDEX in a maintenance plan followed by an update of statistics. The second step is more than just a waste of the maintenance window and CPU, it negates some of the benefit of the reindex (unless a full scan is specified).

  • Chad Crawford

    SSChampion

    Points: 11605

    Shucks.

    I assumed based on the question wording that it was asking if the table statistics (not the index statistics) were updated. Guess I read "on the table" as the target. Sigh... c'est la vie.

    Chad

    Hmm.... I think I just thought of another QOD question... 🙂

  • Anipaul

    SSC-Insane

    Points: 24681

    Good question.

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

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