For SQL 2000,does a dbcc dbreindex update the statistics also? Does an UPDATE
STATISTICS need to be run in addition to dbcc dbreindex to update the
statistics ?
Yes, dbcc dbreindex does update statistics (as opposed to dbcc indexdefrag
which does not)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MANCHO" <MANCHO@.discussions.microsoft.com> wrote in message
news:21E7A1CE-CEE6-4D28-B17F-41979D1CF4F2@.microsoft.com...
> For SQL 2000,does a dbcc dbreindex update the statistics also? Does an
> UPDATE
> STATISTICS need to be run in addition to dbcc dbreindex to update the
> statistics ?
No comments:
Post a Comment