Update Stats with Reindex

Question

Post reply

Update Stats with Reindex

Sugesh Kumar

One Orange Chip

Points: 27311
More actions
August 13, 2008 at 9:01 pm

#195836

Comments posted to this topic are about the item Update Stats with Reindex
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

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

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

Vivien Xing SSChampion Points: 12297 More actions · Answer 1

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: 5061 More actions · Answer 2

rajankjohn

SSCertifiable

Points: 5061

August 14, 2008 at 12:07 am

#857839

How come "Yes" a wrong answer?

Philip Barry SSCrazy Points: 2702 More actions · Answer 3

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 More actions · Answer 4

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: 736478 More actions · Answer 5

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

Cliff Jones SSChampion Points: 10547 More actions · Answer 6

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: 11610 More actions · Answer 7

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 More actions · Answer 8

Anipaul

SSC-Insane

Points: 24681

August 20, 2008 at 1:04 am

#860431

Good question.