"Larry Bertolini" <bertolini.1_at_osu.edu> wrote in message
news:dh9lo2$6o1$1_at_charm.magnus.acs.ohio-state.edu...
> (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
>
>
> Is there any need to run UPDATE STATISTICS after DBCC DBREINDEX?
Oh, I forgot Oracle bought MS SQLServer. Larry, I don't understand why you
are asking this question in an Oracle news group.
Jim
Received on Mon Sep 26 2005 - 20:46:20 CDT
