Question on data optimizations

The database maintenance plan wizards present the ability to do either
data/index page reorgs or update statistics.
Is there any reason you can't do both?
Is it because an update of the statistics is automatically done on a
reorg?

Thanks in advance.
Gerry

Hi

> Is it because an update of the statistics is automatically done on a
> reorg?

When SQL Server rebuild indexes ,statistics ares automatically  to be
updated

"DataPro" <datapro01@yahoo.com> wrote in message
news:1164806696.954151.173330@l39g2000cwd.googlegroups.com...
> The database maintenance plan wizards present the ability to do either
> data/index page reorgs or update statistics.
> Is there any reason you can't do both?
> Is it because an update of the statistics is automatically done on a
> reorg?
>
> Thanks in advance.
> Gerry
>

DataPro  wrote:
> The database maintenance plan wizards present the ability to do either
> data/index page reorgs or update statistics.
> Is there any reason you can't do both?
> Is it because an update of the statistics is automatically done on a
> reorg?
>
> Thanks in advance.
> Gerry
>

Reindexing will update the statistics...


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Hello,

You are correct; Statistics will be updated as part of reindex.

Thanks
Hari

"DataPro" <datapro01@yahoo.com> wrote in message
news:1164806696.954151.173330@l39g2000cwd.googlegroups.com...
> The database maintenance plan wizards present the ability to do either
> data/index page reorgs or update statistics.
> Is there any reason you can't do both?
> Is it because an update of the statistics is automatically done on a
> reorg?
>
> Thanks in advance.
> Gerry
>

Thanks much to all.