DB Maintenance Plan

I have a question on DB Maintenance Plan:
If we create a plan with "Reorganize Data and Index Pages"
selected only, and running the job weekly, do we also need
to set up another job to run sp_updatestats?
Thanks,
Vickyyes
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||That step executes DBCC DBREINDEX which does a full rebuild of the indexes.
The statistics are updated with that rebuild, so there is not need to run
UPDATE STATISTICS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||Oops, thanks Tibor... I read too fast and though she was talking about
backing up the database, not rebuilding indexes.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e$BhynuAEHA.2480@.TK2MSFTNGP12.phx.gbl...
> That step executes DBCC DBREINDEX which does a full rebuild of the
indexes.
> The statistics are updated with that rebuild, so there is not need to run
> UPDATE STATISTICS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vicky" <vickyfan@.hotmail.com> wrote in message
> news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> > I have a question on DB Maintenance Plan:
> >
> > If we create a plan with "Reorganize Data and Index Pages"
> > selected only, and running the job weekly, do we also need
> > to set up another job to run sp_updatestats?
> >
> > Thanks,
> >
> > Vicky
>