InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:49:32 GMT20http://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxGood question.Wed, 20 Aug 2008 01:04:33 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxShucks.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.ChadHmm.... I think I just thought of another QOD question... :)Thu, 14 Aug 2008 08:58:36 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxI 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).Thu, 14 Aug 2008 07:43:56 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxI've updated the question to show partial scan with the plain yes answer and awarded back points.Thu, 14 Aug 2008 07:05:19 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxI 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?Thu, 14 Aug 2008 06:36:30 GMTdunnjoehttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspx[quote][b]Vivien Xing (8/13/2008)[/b][hr]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. [/quote]I agree, 'Yes' is still a valid answer, with a little less qualification.Thu, 14 Aug 2008 03:10:50 GMTPhilip Barryhttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxHow come "Yes" a wrong answer?Thu, 14 Aug 2008 00:07:43 GMTrajankjohnhttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxI 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. Wed, 13 Aug 2008 21:23:20 GMTVivien Xinghttp://www.sqlservercentral.com/Forums/Topic552393-1364-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Maintenance+and+Management/63688/">Update Stats with Reindex</A>[/B]Wed, 13 Aug 2008 21:01:13 GMTSugesh Kumar