Currently, in the maintenance plan, there is a step of reorganise index for
the production database every week.

However, someone says that reorganise index is different from rebuild index
in SQL Server 2005 and we have to run "Update Statistics" as well.

We are confused as in SQL Server 2000, reorganise index and update
statistics are mutually exclusive in the maintenance plan wizard but in SQL
Server 2005, we can select both of them. Is there any change ?

Finally, we would like to confirm that by reorganizing index, the statistics
will be updated. If not, we will add the "Update Statistics" step in the
weekly database maintenance plan.

Thanking you in anticipation.

"Reorganize" in 2005 maint plan mean that ALTER INDEX ... REORGANIZE will be executed. This is same
as DBCC INDEXDEFRAG was in 2000. This was not exposed in 2000 maint plans and the word "reorganize"
in 2000 maintplan was not to be taked literarly. Reorg do not in any way update the statistics.

"Rebuild" causes ALTER INDEX ... REBUILD which is same as DBCC DBREINDEX. This is what the 2000
maint plan could do and this do cause statistics update.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Patrick" <Patrick@discussions.microsoft.com> wrote in message
news:ub96P7xFJHA.4712@TK2MSFTNGP02.phx.gbl...
> Currently, in the maintenance plan, there is a step of reorganise index for the production
> database every week.
>
> However, someone says that reorganise index is different from rebuild index in SQL Server 2005 and
> we have to run "Update Statistics" as well.
>
> We are confused as in SQL Server 2000, reorganise index and update statistics are mutually
> exclusive in the maintenance plan wizard but in SQL Server 2005, we can select both of them. Is
> there any change ?
>
> Finally, we would like to confirm that by reorganizing index, the statistics will be updated. If
> not, we will add the "Update Statistics" step in the weekly database maintenance plan.
>
> Thanking you in anticipation.
>
>
>

Dear Tibor,

Thank you for your prompt reply.

I will add "Update Statistics" in the SQL Server 2005 maintenance plan.
Should I include "Reorganize Index" or I can remove it from the maintenance
plan ?


"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in
message news:%231CRVDyFJHA.768@TK2MSFTNGP05.phx.gbl...
> "Reorganize" in 2005 maint plan mean that ALTER INDEX ... REORGANIZE will
> be executed. This is same as DBCC INDEXDEFRAG was in 2000. This was not
> exposed in 2000 maint plans and the word "reorganize" in 2000 maintplan
> was not to be taked literarly. Reorg do not in any way update the
> statistics.
>
> "Rebuild" causes ALTER INDEX ... REBUILD which is same as DBCC DBREINDEX.
> This is what the 2000 maint plan could do and this do cause statistics
> update.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Patrick" <Patrick@discussions.microsoft.com> wrote in message
> news:ub96P7xFJHA.4712@TK2MSFTNGP02.phx.gbl...
>> Currently, in the maintenance plan, there is a step of reorganise index
>> for the production database every week.
>>
>> However, someone says that reorganise index is different from rebuild
>> index in SQL Server 2005 and we have to run "Update Statistics" as well.
>>
>> We are confused as in SQL Server 2000, reorganise index and update
>> statistics are mutually exclusive in the maintenance plan wizard but in
>> SQL Server 2005, we can select both of them. Is there any change ?
>>
>> Finally, we would like to confirm that by reorganizing index, the
>> statistics will be updated. If not, we will add the "Update Statistics"
>> step in the weekly database maintenance plan.
>>
>> Thanking you in anticipation.
>>
>>
>>
>
>

If you want to defrag, then you either want to include either reorganize or rebuild. Updating of
statistics does not defrag in any way. Here's a good primer on SQL Server fragmentation:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Patrick" <Patrick@discussions.microsoft.com> wrote in message
news:eTrShRyFJHA.768@TK2MSFTNGP05.phx.gbl...
> Dear Tibor,
>
> Thank you for your prompt reply.
>
> I will add "Update Statistics" in the SQL Server 2005 maintenance plan. Should I include
> "Reorganize Index" or I can remove it from the maintenance plan ?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in message
> news:%231CRVDyFJHA.768@TK2MSFTNGP05.phx.gbl...
>> "Reorganize" in 2005 maint plan mean that ALTER INDEX ... REORGANIZE will be executed. This is
>> same as DBCC INDEXDEFRAG was in 2000. This was not exposed in 2000 maint plans and the word
>> "reorganize" in 2000 maintplan was not to be taked literarly. Reorg do not in any way update the
>> statistics.
>>
>> "Rebuild" causes ALTER INDEX ... REBUILD which is same as DBCC DBREINDEX. This is what the 2000
>> maint plan could do and this do cause statistics update.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "Patrick" <Patrick@discussions.microsoft.com> wrote in message
>> news:ub96P7xFJHA.4712@TK2MSFTNGP02.phx.gbl...
>>> Currently, in the maintenance plan, there is a step of reorganise index for the production
>>> database every week.
>>>
>>> However, someone says that reorganise index is different from rebuild index in SQL Server 2005
>>> and we have to run "Update Statistics" as well.
>>>
>>> We are confused as in SQL Server 2000, reorganise index and update statistics are mutually
>>> exclusive in the maintenance plan wizard but in SQL Server 2005, we can select both of them. Is
>>> there any change ?
>>>
>>> Finally, we would like to confirm that by reorganizing index, the statistics will be updated.
>>> If not, we will add the "Update Statistics" step in the weekly database maintenance plan.
>>>
>>> Thanking you in anticipation.
>>>
>>>
>>>
>>
>>
>
>