Wednesday, March 21, 2012

Does rebuilding index update statistics?

Hi, everybody?
I wonder if rebuilding indexes update statistics automatically.
If not, do I have to update statistics separately?
Thanks.Yes, DBREINDEX does. But INDEXDEFRAG does not (Maint Wiz is using DBREINDEX).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message news:OUNg6T7ZDHA.628@.TK2MSFTNGP10.phx.gbl...
> Hi, everybody?
> I wonder if rebuilding indexes update statistics automatically.
> If not, do I have to update statistics separately?
> Thanks.
>
>sql

No comments:

Post a Comment