Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
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 FULLSCAN
Post Follow-up to this message
Re: Does DBCC DBREINDEX update stats?DBCC DBREINDEX updates the statistics, while DBCC INDEXDEFRAG does not http://sqlservercode.blogspot.com/
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
