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.

GerryIf by "The rebuild index switch is SQL Server speak for a reorg correct?" you mean reorganinzing the data pages similiar to what a dbcc shrinkdatabase does then the answer is no.

The -ReblIdx switch refers to rebuilding indexes.

From BOL: -RebldIdx free_space

Specifies that indexes on tables in the target database should be rebuilt by using the free_space percent value as the inverse of the fill factor. For example, if free_space percentage is 30, then the fill factor used is 70. If a free_space percentage value of 100 is specified, then the indexes are rebuilt with the original fill factor value.

best regards|||I am trying to determine if any reorgs have been done. What flag/switch in the sqlmaint should I be looking for?

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 perfo
rmed. 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
>

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
>