Question on sqlmaint scripts

New to SQL Server.
I am looking at some legacy sqlmaint scripts.
If I don't see the switches
ReblIdx
or
UpdOptiStats
Does that mean that there are no database reorgs and no update system
catalog statistics being done?
The rebuild index switch is SQL Server speak for a reorg correct?
Thanks in advance.
Gerry> Does that mean that there are no database reorgs and no update system
> catalog statistics being done?
The easiest way to find out is to run a Profiler trace.
But, if the switches aren't specified, then the operations will not be performed. Btw, if you
rebuild the indexes, then there is no reason to also update statistics.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1166124228.815216.74360@.n67g2000cwd.googlegroups.com...
> New to SQL Server.
> I am looking at some legacy sqlmaint scripts.
> If I don't see the switches
> ReblIdx
> or
> UpdOptiStats
>
> Does that mean that there are no database reorgs and no update system
> catalog statistics being done?
> The rebuild index switch is SQL Server speak for a reorg correct?
> Thanks in advance.
> Gerry
>