Microsoft SQL Server forum - Does DBCC DBREINDEX update stats?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Does DBCC DBREINDEX update stats?

Larry Bertolini

2005-09-26, 8:24 pm

(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 FULLSCAN

SQL

2005-09-26, 8:24 pm

DBCC DBREINDEX updates the statistics, while DBCC INDEXDEFRAG does not

http://sqlservercode.blogspot.com/

Sponsored Links