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