I've read
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
and I understand that "Updating statistics is a side effect of DBCC
DBREINDEX". But is that update done the equivalent of a WITH FULLSCAN
update, or the default sampling update?
Thanks!
Stephen SkrzydloYes, it is same as FULLSCAN. Since all rows are touched when doing REBUILD,
it would be foolish not
to base the new statistics on all the data.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Stephen Skrzydlo" <Stephen Skrzydlo@.discussions.microsoft.com> wrote in mes
sage
news:2582A848-B6ED-4B85-8ACD-10A846CB7C15@.microsoft.com...
> I've read
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx[/ur
l]
> and I understand that "Updating statistics is a side effect of DBCC
> DBREINDEX". But is that update done the equivalent of a WITH FULLSCAN
> update, or the default sampling update?
> Thanks!
> Stephen Skrzydlo
No comments:
Post a Comment