Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Update Stats with Reindex Expand / Collapse
Author
Message
Posted Wednesday, August 13, 2008 9:01 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, June 28, 2013 8:25 AM
Points: 3,461, Visits: 347
Comments posted to this topic are about the item Update Stats with Reindex

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #552393
Posted Wednesday, August 13, 2008 9:23 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 2:49 PM
Points: 1,279, Visits: 2,203
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.

Post #552397
Posted Thursday, August 14, 2008 12:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:36 AM
Points: 1,199, Visits: 574
How come "Yes" a wrong answer?
Post #552427
Posted Thursday, August 14, 2008 3:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 20, 2014 4:03 AM
Points: 1,396, Visits: 549
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
Post #552506
Posted Thursday, August 14, 2008 6:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, March 31, 2011 1:40 AM
Points: 1,938, Visits: 208
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?
Post #552615
Posted Thursday, August 14, 2008 7:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:56 PM
Points: 32,771, Visits: 14,935
I've updated the question to show partial scan with the plain yes answer and awarded back points.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #552641
Posted Thursday, August 14, 2008 7:43 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 3,766, Visits: 3,584

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).
Post #552682
Posted Thursday, August 14, 2008 8:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 04, 2014 8:25 AM
Points: 2,602, Visits: 17,845
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... :)
Post #552794
Posted Wednesday, August 20, 2008 1:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,191, Visits: 1,368
Good question.


Post #555546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse