| Author |
Question on data optimizations
|
|
| DataPro 2006-11-29, 7:12 pm |
| 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
| |
| Uri Dimant 2006-11-29, 7:12 pm |
| 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
>
| |
| Tracy McKibben 2006-11-29, 7:12 pm |
| 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
| |
| Hari Prasad 2006-11-29, 7:12 pm |
| 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
>
| |
| DataPro 2006-11-29, 7:12 pm |
| Thanks much to all.
|
|
|
|