|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Friday, October 23, 2009 7:16 AM
Points: 3,461,
Visits: 287
|
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 1,268,
Visits: 1,914
|
|
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.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, June 11, 2009 6:22 AM
Points: 1,182,
Visits: 475
|
|
| How come "Yes" a wrong answer?
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 733,
Visits: 401
|
|
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
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:05 AM
Points: 1,583,
Visits: 133
|
|
| 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?
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 10:32 AM
Points: 21,891,
Visits: 6,104
|
|
| I've updated the question to show partial scan with the plain yes answer and awarded back points.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 7:02 AM
Points: 1,601,
Visits: 983
|
|
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).
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 1,715,
Visits: 1,314
|
|
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... :)
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Thursday, November 12, 2009 7:14 AM
Points: 3,295,
Visits: 964
|
|
|
|
|
