Friday, March 9, 2012

Does DBCC DBREINDEX update stats?

(Assuming SQL Server 2000, auto create statistics on, auto update
statistics on.)

Does

DBCC DBREINDEX(<tablename>)

update statistics? If yes, are the statistics equivalent to those
that would be produced by:

UPDATE STATISTICS <tablename> WITH FULLSCANDBCC DBREINDEX updates the statistics, while DBCC INDEXDEFRAG does not

http://sqlservercode.blogspot.com/

No comments:

Post a Comment